This project is to demonstrate the understanding of data science process and to apply it real data set.
The data set I chose is provided by AirBNB, the house sharing company for the West Coast City of Seattle,
I will follow CRISP-DM process in the analysis of this data set.
The data is divided in three files:
The data have many features to analyze, I will choose the ones related to customers and neighborhoods.
I will do some data exploration and visualizations to answer the following questions:
Q1: Are Customers Happy?
Q2: Where listings are concentrated?
Q3: How much the customer is paying to stay in Seattle with AirBNB?
Q4: What are the average prices for each neighborhood?
# import libraries here; add more as necessary
import numpy as np
import pandas as pd
import math
import json
import pickle
from datetime import datetime as dt
from IPython.display import display, HTML
import plotly
import re
import ast
import sys
np.set_printoptions(threshold=sys.maxsize)
print(sys.version)
pd.set_option('display.max_columns', 500)
import chart_studio as py
import plotly.graph_objects as go
import plotly.io as pio
import plotly.express as px
3.7.3 (default, Mar 27 2019, 22:11:17) [GCC 7.3.0]
Here I will load each of the files and do some exploration
# read in the csv files
calendar = pd.read_csv('calendar.csv')
listings = pd.read_csv('listings.csv')
reviews = pd.read_csv('reviews.csv')
calendar
| listing_id | date | available | price | |
|---|---|---|---|---|
| 0 | 241032 | 2016-01-04 | t | $85.00 |
| 1 | 241032 | 2016-01-05 | t | $85.00 |
| 2 | 241032 | 2016-01-06 | f | NaN |
| 3 | 241032 | 2016-01-07 | f | NaN |
| 4 | 241032 | 2016-01-08 | f | NaN |
| 5 | 241032 | 2016-01-09 | f | NaN |
| 6 | 241032 | 2016-01-10 | f | NaN |
| 7 | 241032 | 2016-01-11 | f | NaN |
| 8 | 241032 | 2016-01-12 | f | NaN |
| 9 | 241032 | 2016-01-13 | t | $85.00 |
| 10 | 241032 | 2016-01-14 | t | $85.00 |
| 11 | 241032 | 2016-01-15 | f | NaN |
| 12 | 241032 | 2016-01-16 | f | NaN |
| 13 | 241032 | 2016-01-17 | f | NaN |
| 14 | 241032 | 2016-01-18 | t | $85.00 |
| 15 | 241032 | 2016-01-19 | t | $85.00 |
| 16 | 241032 | 2016-01-20 | t | $85.00 |
| 17 | 241032 | 2016-01-21 | f | NaN |
| 18 | 241032 | 2016-01-22 | f | NaN |
| 19 | 241032 | 2016-01-23 | f | NaN |
| 20 | 241032 | 2016-01-24 | t | $85.00 |
| 21 | 241032 | 2016-01-25 | t | $85.00 |
| 22 | 241032 | 2016-01-26 | t | $85.00 |
| 23 | 241032 | 2016-01-27 | t | $85.00 |
| 24 | 241032 | 2016-01-28 | t | $85.00 |
| 25 | 241032 | 2016-01-29 | f | NaN |
| 26 | 241032 | 2016-01-30 | f | NaN |
| 27 | 241032 | 2016-01-31 | f | NaN |
| 28 | 241032 | 2016-02-01 | t | $85.00 |
| 29 | 241032 | 2016-02-02 | t | $85.00 |
| ... | ... | ... | ... | ... |
| 1393540 | 10208623 | 2016-12-04 | f | NaN |
| 1393541 | 10208623 | 2016-12-05 | f | NaN |
| 1393542 | 10208623 | 2016-12-06 | f | NaN |
| 1393543 | 10208623 | 2016-12-07 | f | NaN |
| 1393544 | 10208623 | 2016-12-08 | f | NaN |
| 1393545 | 10208623 | 2016-12-09 | f | NaN |
| 1393546 | 10208623 | 2016-12-10 | f | NaN |
| 1393547 | 10208623 | 2016-12-11 | f | NaN |
| 1393548 | 10208623 | 2016-12-12 | f | NaN |
| 1393549 | 10208623 | 2016-12-13 | f | NaN |
| 1393550 | 10208623 | 2016-12-14 | f | NaN |
| 1393551 | 10208623 | 2016-12-15 | f | NaN |
| 1393552 | 10208623 | 2016-12-16 | f | NaN |
| 1393553 | 10208623 | 2016-12-17 | f | NaN |
| 1393554 | 10208623 | 2016-12-18 | f | NaN |
| 1393555 | 10208623 | 2016-12-19 | f | NaN |
| 1393556 | 10208623 | 2016-12-20 | f | NaN |
| 1393557 | 10208623 | 2016-12-21 | f | NaN |
| 1393558 | 10208623 | 2016-12-22 | f | NaN |
| 1393559 | 10208623 | 2016-12-23 | f | NaN |
| 1393560 | 10208623 | 2016-12-24 | f | NaN |
| 1393561 | 10208623 | 2016-12-25 | f | NaN |
| 1393562 | 10208623 | 2016-12-26 | f | NaN |
| 1393563 | 10208623 | 2016-12-27 | f | NaN |
| 1393564 | 10208623 | 2016-12-28 | f | NaN |
| 1393565 | 10208623 | 2016-12-29 | f | NaN |
| 1393566 | 10208623 | 2016-12-30 | f | NaN |
| 1393567 | 10208623 | 2016-12-31 | f | NaN |
| 1393568 | 10208623 | 2017-01-01 | f | NaN |
| 1393569 | 10208623 | 2017-01-02 | f | NaN |
1393570 rows × 4 columns
listings
| id | listing_url | scrape_id | last_scraped | name | summary | space | description | experiences_offered | neighborhood_overview | notes | transit | thumbnail_url | medium_url | picture_url | xl_picture_url | host_id | host_url | host_name | host_since | host_location | host_about | host_response_time | host_response_rate | host_acceptance_rate | host_is_superhost | host_thumbnail_url | host_picture_url | host_neighbourhood | host_listings_count | host_total_listings_count | host_verifications | host_has_profile_pic | host_identity_verified | street | neighbourhood | neighbourhood_cleansed | neighbourhood_group_cleansed | city | state | zipcode | market | smart_location | country_code | country | latitude | longitude | is_location_exact | property_type | room_type | accommodates | bathrooms | bedrooms | beds | bed_type | amenities | square_feet | price | weekly_price | monthly_price | security_deposit | cleaning_fee | guests_included | extra_people | minimum_nights | maximum_nights | calendar_updated | has_availability | availability_30 | availability_60 | availability_90 | availability_365 | calendar_last_scraped | number_of_reviews | first_review | last_review | review_scores_rating | review_scores_accuracy | review_scores_cleanliness | review_scores_checkin | review_scores_communication | review_scores_location | review_scores_value | requires_license | license | jurisdiction_names | instant_bookable | cancellation_policy | require_guest_profile_picture | require_guest_phone_verification | calculated_host_listings_count | reviews_per_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 241032 | https://www.airbnb.com/rooms/241032 | 20160104002432 | 2016-01-04 | Stylish Queen Anne Apartment | NaN | Make your self at home in this charming one-be... | Make your self at home in this charming one-be... | none | NaN | NaN | NaN | NaN | NaN | https://a1.muscache.com/ac/pictures/67560560/c... | NaN | 956883 | https://www.airbnb.com/users/show/956883 | Maija | 2011-08-11 | Seattle, Washington, United States | I am an artist, interior designer, and run a s... | within a few hours | 96% | 100% | f | https://a0.muscache.com/ac/users/956883/profil... | https://a0.muscache.com/ac/users/956883/profil... | Queen Anne | 3.0 | 3.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | Gilman Dr W, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.636289 | -122.371025 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $85.00 | NaN | NaN | NaN | NaN | 2 | $5.00 | 1 | 365 | 4 weeks ago | t | 14 | 41 | 71 | 346 | 2016-01-04 | 207 | 2011-11-01 | 2016-01-02 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 2 | 4.07 |
| 1 | 953595 | https://www.airbnb.com/rooms/953595 | 20160104002432 | 2016-01-04 | Bright & Airy Queen Anne Apartment | Chemically sensitive? We've removed the irrita... | Beautiful, hypoallergenic apartment in an extr... | Chemically sensitive? We've removed the irrita... | none | Queen Anne is a wonderful, truly functional vi... | What's up with the free pillows? Our home was... | Convenient bus stops are just down the block, ... | https://a0.muscache.com/ac/pictures/14409893/f... | https://a0.muscache.com/im/pictures/14409893/f... | https://a0.muscache.com/ac/pictures/14409893/f... | https://a0.muscache.com/ac/pictures/14409893/f... | 5177328 | https://www.airbnb.com/users/show/5177328 | Andrea | 2013-02-21 | Seattle, Washington, United States | Living east coast/left coast/overseas. Time i... | within an hour | 98% | 100% | t | https://a0.muscache.com/ac/users/5177328/profi... | https://a0.muscache.com/ac/users/5177328/profi... | Queen Anne | 6.0 | 6.0 | ['email', 'phone', 'facebook', 'linkedin', 're... | t | t | 7th Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.639123 | -122.365666 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,"Free... | NaN | $150.00 | $1,000.00 | $3,000.00 | $100.00 | $40.00 | 1 | $0.00 | 2 | 90 | today | t | 13 | 13 | 16 | 291 | 2016-01-04 | 43 | 2013-08-19 | 2015-12-29 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | t | t | 6 | 1.48 |
| 2 | 3308979 | https://www.airbnb.com/rooms/3308979 | 20160104002432 | 2016-01-04 | New Modern House-Amazing water view | New modern house built in 2013. Spectacular s... | Our house is modern, light and fresh with a wa... | New modern house built in 2013. Spectacular s... | none | Upper Queen Anne is a charming neighborhood fu... | Our house is located just 5 short blocks to To... | A bus stop is just 2 blocks away. Easy bus a... | NaN | NaN | https://a2.muscache.com/ac/pictures/b4324e0f-a... | NaN | 16708587 | https://www.airbnb.com/users/show/16708587 | Jill | 2014-06-12 | Seattle, Washington, United States | i love living in Seattle. i grew up in the mi... | within a few hours | 67% | 100% | f | https://a1.muscache.com/ac/users/16708587/prof... | https://a1.muscache.com/ac/users/16708587/prof... | Queen Anne | 2.0 | 2.0 | ['email', 'phone', 'google', 'reviews', 'jumio'] | t | t | West Lee Street, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.629724 | -122.369483 | t | House | Entire home/apt | 11 | 4.5 | 5.0 | 7.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $975.00 | NaN | NaN | $1,000.00 | $300.00 | 10 | $25.00 | 4 | 30 | 5 weeks ago | t | 1 | 6 | 17 | 220 | 2016-01-04 | 20 | 2014-07-30 | 2015-09-03 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 2 | 1.15 |
| 3 | 7421966 | https://www.airbnb.com/rooms/7421966 | 20160104002432 | 2016-01-04 | Queen Anne Chateau | A charming apartment that sits atop Queen Anne... | NaN | A charming apartment that sits atop Queen Anne... | none | NaN | NaN | NaN | NaN | NaN | https://a0.muscache.com/ac/pictures/94146944/6... | NaN | 9851441 | https://www.airbnb.com/users/show/9851441 | Emily | 2013-11-06 | Seattle, Washington, United States | NaN | NaN | NaN | NaN | f | https://a2.muscache.com/ac/users/9851441/profi... | https://a2.muscache.com/ac/users/9851441/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'jum... | t | t | 8th Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.638473 | -122.369279 | t | Apartment | Entire home/apt | 3 | 1.0 | 0.0 | 2.0 | Real Bed | {Internet,"Wireless Internet",Kitchen,"Indoor ... | NaN | $100.00 | $650.00 | $2,300.00 | NaN | NaN | 1 | $0.00 | 1 | 1125 | 6 months ago | t | 0 | 0 | 0 | 143 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
| 4 | 278830 | https://www.airbnb.com/rooms/278830 | 20160104002432 | 2016-01-04 | Charming craftsman 3 bdm house | Cozy family craftman house in beautiful neighb... | Cozy family craftman house in beautiful neighb... | Cozy family craftman house in beautiful neighb... | none | We are in the beautiful neighborhood of Queen ... | Belltown | The nearest public transit bus (D Line) is 2 b... | NaN | NaN | https://a1.muscache.com/ac/pictures/6120468/b0... | NaN | 1452570 | https://www.airbnb.com/users/show/1452570 | Emily | 2011-11-29 | Seattle, Washington, United States | Hi, I live in Seattle, Washington but I'm orig... | within an hour | 100% | NaN | f | https://a0.muscache.com/ac/users/1452570/profi... | https://a0.muscache.com/ac/users/1452570/profi... | Queen Anne | 2.0 | 2.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | 14th Ave W, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.632918 | -122.372471 | t | House | Entire home/apt | 6 | 2.0 | 3.0 | 3.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $450.00 | NaN | NaN | $700.00 | $125.00 | 6 | $15.00 | 1 | 1125 | 7 weeks ago | t | 30 | 60 | 90 | 365 | 2016-01-04 | 38 | 2012-07-10 | 2015-10-24 | 92.0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 9.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 0.89 |
| 5 | 5956968 | https://www.airbnb.com/rooms/5956968 | 20160104002432 | 2016-01-04 | Private unit in a 1920s mansion | We're renting out a small private unit of one ... | If you include a bit of your background in you... | We're renting out a small private unit of one ... | none | This part of Queen Anne has wonderful views an... | Let me know if you need anything or have sugge... | The #1 and #2 bus picks up 2-3 blocks away (di... | https://a2.muscache.com/ac/pictures/84791950/f... | https://a2.muscache.com/im/pictures/84791950/f... | https://a2.muscache.com/ac/pictures/84791950/f... | https://a2.muscache.com/ac/pictures/84791950/f... | 326758 | https://www.airbnb.com/users/show/326758 | Andrew | 2010-12-25 | Seattle, Washington, United States | I've been fortunate to have had many life expe... | NaN | NaN | NaN | f | https://a2.muscache.com/ac/users/326758/profil... | https://a2.muscache.com/ac/users/326758/profil... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | West Comstock Street, Seattle, WA 98119, Unite... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.630525 | -122.366174 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wireless Internet","Free Parking on Premises... | NaN | $120.00 | $800.00 | NaN | NaN | $40.00 | 1 | $30.00 | 1 | 6 | 2 weeks ago | t | 0 | 0 | 27 | 302 | 2016-01-04 | 17 | 2015-06-11 | 2015-09-28 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 2.45 |
| 6 | 1909058 | https://www.airbnb.com/rooms/1909058 | 20160104002432 | 2016-01-04 | Queen Anne Private Bed and Bath | Enjoy a quiet stay in our comfortable 1915 Cra... | Enjoy a quiet stay in our comfortable 1915 Cra... | Enjoy a quiet stay in our comfortable 1915 Cra... | none | Close restaurants, coffee shops and grocery st... | The room now has a mini frig to keep your favo... | The bus goes through the lower Queen Anne neig... | https://a2.muscache.com/ac/pictures/26505642/2... | https://a2.muscache.com/im/pictures/26505642/2... | https://a2.muscache.com/ac/pictures/26505642/2... | https://a2.muscache.com/ac/pictures/26505642/2... | 2497928 | https://www.airbnb.com/users/show/2497928 | Gary And Beth | 2012-05-30 | Seattle, Washington, United States | We have lived in the the Queen Anne neighborho... | within an hour | 100% | 100% | t | https://a0.muscache.com/ac/users/2497928/profi... | https://a0.muscache.com/ac/users/2497928/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | 10th Avenue West, Seattle, WA 98119, United St... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.636605 | -122.368519 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wireless Internet","Free Parking on Premises... | NaN | $80.00 | $575.00 | NaN | $150.00 | NaN | 1 | $10.00 | 3 | 14 | 5 weeks ago | t | 20 | 49 | 71 | 346 | 2016-01-04 | 58 | 2014-01-27 | 2015-12-07 | 99.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 2.46 |
| 7 | 856550 | https://www.airbnb.com/rooms/856550 | 20160104002432 | 2016-01-04 | Tiny Garden cabin on Queen Anne | Our tiny cabin is private , very quiet and com... | This cabin was built with Airbnb in mind, Que... | Our tiny cabin is private , very quiet and com... | none | We are centrally located between Downtown and ... | There are three rentals in our back yard . If ... | the "D" line runs out in front of our house . | https://a2.muscache.com/ac/pictures/83538305/d... | https://a2.muscache.com/im/pictures/83538305/d... | https://a2.muscache.com/ac/pictures/83538305/d... | https://a2.muscache.com/ac/pictures/83538305/d... | 4016632 | https://www.airbnb.com/users/show/4016632 | Jean-Marc | 2012-10-30 | Seattle, Washington, United States | I am a carpenter at heart , I love music , I p... | within an hour | 100% | 100% | t | https://a1.muscache.com/ac/users/4016632/profi... | https://a1.muscache.com/ac/users/4016632/profi... | Queen Anne | 5.0 | 5.0 | ['email', 'phone', 'facebook', 'google', 'link... | t | t | West Wheeler Street, Seattle, WA 98119, United... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.640161 | -122.375856 | t | Cabin | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wireless Internet","Pets live on this proper... | NaN | $60.00 | $360.00 | NaN | $150.00 | $25.00 | 1 | $0.00 | 2 | 7 | yesterday | t | 22 | 42 | 42 | 100 | 2016-01-04 | 173 | 2013-01-03 | 2016-01-01 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | f | NaN | WASHINGTON | f | strict | t | t | 5 | 4.73 |
| 8 | 4948745 | https://www.airbnb.com/rooms/4948745 | 20160104002432 | 2016-01-04 | Urban Charm || Downtown || Views | Nestled in the heart of the city, this space i... | Located in the heart of the city, this space i... | Nestled in the heart of the city, this space i... | none | Walking Score: 92 4 blocks from Kerry Park Fam... | NaN | Bus stop to downtown directly across the stree... | https://a0.muscache.com/ac/pictures/85453284/d... | https://a0.muscache.com/im/pictures/85453284/d... | https://a0.muscache.com/ac/pictures/85453284/d... | https://a0.muscache.com/ac/pictures/85453284/d... | 2166277 | https://www.airbnb.com/users/show/2166277 | Aliza | 2012-04-18 | Seattle, Washington, United States | I'm a 35 year old professional from Seattle, W... | NaN | NaN | 100% | f | https://a1.muscache.com/ac/users/2166277/profi... | https://a1.muscache.com/ac/users/2166277/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'linkedin', 're... | t | t | Queen Anne Avenue North, Seattle, WA 98109, Un... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98109 | Seattle | Seattle, WA | US | United States | 47.632410 | -122.357216 | t | Apartment | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $90.00 | $500.00 | $1,700.00 | NaN | NaN | 1 | $0.00 | 3 | 1125 | 5 months ago | t | 6 | 36 | 66 | 341 | 2016-01-04 | 8 | 2015-06-22 | 2015-08-17 | 97.0 | 10.0 | 9.0 | 10.0 | 9.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 1.22 |
| 9 | 2493658 | https://www.airbnb.com/rooms/2493658 | 20160104002432 | 2016-01-04 | Airy + Bright Queen Anne Apartment | Beautiful apartment in an extremely safe, quie... | What's special about this place? A beautiful r... | Beautiful apartment in an extremely safe, quie... | none | Queen Anne is a wonderful, truly functional vi... | What's up with the free pillows? Our home was... | Convenient bus stops are just down the block, ... | https://a2.muscache.com/ac/pictures/33003258/f... | https://a2.muscache.com/im/pictures/33003258/f... | https://a2.muscache.com/ac/pictures/33003258/f... | https://a2.muscache.com/ac/pictures/33003258/f... | 5177328 | https://www.airbnb.com/users/show/5177328 | Andrea | 2013-02-21 | Seattle, Washington, United States | Living east coast/left coast/overseas. Time i... | within an hour | 98% | 100% | t | https://a0.muscache.com/ac/users/5177328/profi... | https://a0.muscache.com/ac/users/5177328/profi... | Queen Anne | 6.0 | 6.0 | ['email', 'phone', 'facebook', 'linkedin', 're... | t | t | 7th Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.637492 | -122.366889 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,"Free... | NaN | $150.00 | $1,000.00 | $3,000.00 | $100.00 | $40.00 | 1 | $0.00 | 2 | 365 | today | t | 6 | 19 | 49 | 324 | 2016-01-04 | 32 | 2014-04-27 | 2015-12-20 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | f | NaN | WASHINGTON | f | strict | t | t | 6 | 1.55 |
| 10 | 175576 | https://www.airbnb.com/rooms/175576 | 20160104002432 | 2016-01-04 | Private Apartment - Queen Anne Hill | Queen Anne Hill is a charming neighborhood wit... | Be close to everything! Queen Anne Hill is a ... | Queen Anne Hill is a charming neighborhood wit... | none | Queen Anne Hill is a wonderful and historic ar... | We will provide you with a Parking Pass to han... | The bus stop is just two blocks from our house... | https://a0.muscache.com/ac/pictures/2788698/87... | https://a0.muscache.com/im/pictures/2788698/87... | https://a0.muscache.com/ac/pictures/2788698/87... | https://a0.muscache.com/ac/pictures/2788698/87... | 239585 | https://www.airbnb.com/users/show/239585 | Ray & Eileen | 2010-09-19 | Seattle, Washington, United States | Eileen and Ray were born in Seattle just three... | within a few hours | 100% | 100% | t | https://a2.muscache.com/ac/users/239585/profil... | https://a2.muscache.com/ac/users/239585/profil... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | 1st Ave W, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.635482 | -122.358478 | t | House | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $95.00 | $595.00 | NaN | NaN | $15.00 | 2 | $15.00 | 3 | 7 | a week ago | t | 0 | 0 | 0 | 153 | 2016-01-04 | 181 | 2011-07-21 | 2015-11-25 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | t | f | 1 | 3.33 |
| 11 | 4454295 | https://www.airbnb.com/rooms/4454295 | 20160104002432 | 2016-01-04 | Upper Queen Anne Craftsman House | Beautifully furnished, cozy 1 bedroom mid cent... | Beautiful home in an extremely walkable neighb... | Beautifully furnished, cozy 1 bedroom mid cent... | none | I am located in the Upper Queen Anne neighborh... | NaN | Yes, bus stops just 2-3 blocks away. | https://a0.muscache.com/ac/pictures/59566840/b... | https://a0.muscache.com/im/pictures/59566840/b... | https://a0.muscache.com/ac/pictures/59566840/b... | https://a0.muscache.com/ac/pictures/59566840/b... | 4606439 | https://www.airbnb.com/users/show/4606439 | Nadia | 2013-01-06 | Seattle, Washington, United States | My name is Nadia, and I am a native of Seattle... | within a few hours | 100% | 100% | f | https://a1.muscache.com/ac/users/4606439/profi... | https://a1.muscache.com/ac/users/4606439/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | 3rd Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.637214 | -122.360046 | t | House | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... | NaN | $99.00 | $800.00 | $2,000.00 | $500.00 | $150.00 | 1 | $0.00 | 3 | 1125 | a week ago | t | 21 | 21 | 21 | 229 | 2016-01-04 | 8 | 2015-05-06 | 2015-12-16 | 97.0 | 10.0 | 10.0 | 9.0 | 10.0 | 10.0 | 9.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 0.98 |
| 12 | 3883392 | https://www.airbnb.com/rooms/3883392 | 20160104002432 | 2016-01-04 | Open Plan 2bdr/1bath in Queen Anne | Spacious apt in popular Seattle neighborhood. ... | This apartment is in a quiet and friendly city... | Spacious apt in popular Seattle neighborhood. ... | none | This neighborhood is one of Seattle's popular ... | Seattle is a "green" town. Composting and re... | #1 bus is one block from the house to downtown... | https://a2.muscache.com/ac/pictures/48864586/9... | https://a2.muscache.com/im/pictures/48864586/9... | https://a2.muscache.com/ac/pictures/48864586/9... | https://a2.muscache.com/ac/pictures/48864586/9... | 19932967 | https://www.airbnb.com/users/show/19932967 | Pat & Roberta | 2014-08-13 | Seattle, Washington, United States | We both grew up on Queen Anne Hill, then later... | within an hour | 100% | 100% | t | https://a1.muscache.com/ac/users/19932967/prof... | https://a1.muscache.com/ac/users/19932967/prof... | NaN | 1.0 | 1.0 | ['email', 'phone', 'linkedin', 'reviews', 'jum... | t | t | West Howe Street, Seattle, WA 98119, United St... | NaN | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.635546 | -122.373171 | t | Apartment | Entire home/apt | 4 | 1.0 | 2.0 | 3.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $245.00 | $1,575.00 | $5,800.00 | $300.00 | $95.00 | 1 | $0.00 | 3 | 14 | 2 weeks ago | t | 30 | 60 | 90 | 362 | 2016-01-04 | 13 | 2014-11-09 | 2015-10-02 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 0.92 |
| 13 | 8889257 | https://www.airbnb.com/rooms/8889257 | 20160104002432 | 2016-01-04 | Elegance in Historic Queen Anne | Enjoy our amazing, updated & modern design cot... | Originally built in 1906, our house has a ligh... | Enjoy our amazing, updated & modern design cot... | none | Queen Anne hill became a popular spot for the ... | NaN | Street parking only. From West Prospect, park ... | https://a2.muscache.com/ac/pictures/69b4dfed-9... | https://a2.muscache.com/im/pictures/69b4dfed-9... | https://a2.muscache.com/ac/pictures/69b4dfed-9... | https://a2.muscache.com/ac/pictures/69b4dfed-9... | 25899989 | https://www.airbnb.com/users/show/25899989 | Ellie | 2015-01-10 | Kirkland, Washington, United States | Hi, my name is Ellie. I’m a widow. My husban... | within an hour | 100% | 100% | f | https://a2.muscache.com/ac/pictures/5eee2738-1... | https://a2.muscache.com/ac/pictures/5eee2738-1... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | West Prospect Street, Seattle, WA 98119, Unite... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.629507 | -122.367629 | t | House | Entire home/apt | 5 | 1.0 | 2.0 | 3.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $165.00 | NaN | $5,000.00 | $400.00 | $85.00 | 4 | $20.00 | 2 | 1125 | today | t | 13 | 40 | 63 | 337 | 2016-01-04 | 3 | 2015-12-16 | 2016-01-02 | 100.0 | 10.0 | 10.0 | 9.0 | 9.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 3.00 |
| 14 | 5680462 | https://www.airbnb.com/rooms/5680462 | 20160104002432 | 2016-01-04 | Stunning 6 bd in THE BEST Location! | Stunning Designsponge featured 6 bed, 3.75 bat... | Gorgeous, LIGHT FILLED, Newly Constructed Mode... | Stunning Designsponge featured 6 bed, 3.75 bat... | none | Queen Anne is THE BEST and most desirable neig... | The house is great for large groups or extende... | Hwy 99 and the 5 freeway are both easy to get ... | https://a2.muscache.com/ac/pictures/91278310/1... | https://a2.muscache.com/im/pictures/91278310/1... | https://a2.muscache.com/ac/pictures/91278310/1... | https://a2.muscache.com/ac/pictures/91278310/1... | 22372266 | https://www.airbnb.com/users/show/22372266 | Sarah | 2014-10-10 | Seattle, Washington, United States | Originally from Southern California, my husban... | within an hour | 100% | 100% | f | https://a2.muscache.com/ac/users/22372266/prof... | https://a2.muscache.com/ac/users/22372266/prof... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | 7th Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.639203 | -122.365863 | t | House | Entire home/apt | 16 | 3.5 | 6.0 | 15.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $461.00 | NaN | NaN | $1,500.00 | $300.00 | 8 | $50.00 | 3 | 29 | 5 days ago | t | 19 | 40 | 65 | 327 | 2016-01-04 | 18 | 2015-06-15 | 2015-11-15 | 98.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | t | strict | f | f | 1 | 2.65 |
| 15 | 8988178 | https://www.airbnb.com/rooms/8988178 | 20160104002432 | 2016-01-04 | Lovely Queen Anne Cottage, 2 BR | This home is full of light, art and comfort. 5... | The Space This is a 1000 square foot, two bedr... | This home is full of light, art and comfort. 5... | none | Queen Anne is a charming and very safe neighbo... | NaN | You will be 2 blocks from the Metro stop. On ... | NaN | NaN | https://a2.muscache.com/ac/pictures/fa176cce-b... | NaN | 2983711 | https://www.airbnb.com/users/show/2983711 | Paige | 2012-07-18 | Seattle, Washington, United States | I'm from Seattle. I am a designer, inventor a... | within a few hours | 100% | 100% | f | https://a0.muscache.com/ac/users/2983711/profi... | https://a0.muscache.com/ac/users/2983711/profi... | NaN | 1.0 | 1.0 | ['email', 'reviews', 'kba'] | t | f | 12th Avenue West, Seattle, WA 98119, United St... | NaN | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.635650 | -122.372893 | f | House | Entire home/apt | 5 | 1.0 | 2.0 | 2.0 | Real Bed | {TV,"Cable TV",Internet,Kitchen,"Free Parking ... | NaN | $109.00 | NaN | NaN | NaN | $89.00 | 1 | $0.00 | 3 | 15 | 3 days ago | t | 30 | 60 | 69 | 69 | 2016-01-04 | 1 | 2015-11-25 | 2015-11-25 | 80.0 | 8.0 | 10.0 | 8.0 | 8.0 | 8.0 | 8.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 0.73 |
| 16 | 3245876 | https://www.airbnb.com/rooms/3245876 | 20160104002432 | 2016-01-04 | Park Life in Lower Queen Anne | Master bedroom suite with 1/4 bath & kitchenet... | **PLEASE MAKE SURE TO READ ALL INFO BEFORE BOO... | Master bedroom suite with 1/4 bath & kitchenet... | none | Lower Queen Anne is amazing - you can walk to ... | I have two cats, Tori Spelling and Denzel. The... | Taxi: Uber, Sidecar, and Lyft are all availabl... | https://a0.muscache.com/ac/pictures/57011178/e... | https://a0.muscache.com/im/pictures/57011178/e... | https://a0.muscache.com/ac/pictures/57011178/e... | https://a0.muscache.com/ac/pictures/57011178/e... | 9465817 | https://www.airbnb.com/users/show/9465817 | Libby | 2013-10-16 | Seattle, Washington, United States | I'm a 37 year old recent law school graduate, ... | within an hour | 100% | 100% | f | https://a2.muscache.com/ac/users/9465817/profi... | https://a2.muscache.com/ac/users/9465817/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'linkedin', 're... | t | t | West Mercer Place, Seattle, WA 98119, United S... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.626200 | -122.366602 | t | Apartment | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {Internet,"Wireless Internet","Pets Allowed",B... | NaN | $66.00 | NaN | NaN | $100.00 | $35.00 | 1 | $25.00 | 1 | 10 | yesterday | t | 29 | 59 | 89 | 364 | 2016-01-04 | 84 | 2014-06-30 | 2016-01-02 | 95.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 9.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 4.55 |
| 17 | 4933447 | https://www.airbnb.com/rooms/4933447 | 20160104002432 | 2016-01-04 | Private Garden Suite, Bay View | Beautiful private entrance garden suite overlo... | French Country style home built in 1939 with s... | Beautiful private entrance garden suite overlo... | none | We are located in Upper Queen Anne in walking ... | Electric hot water kettle provided for hot bev... | Our central location means quick access to all... | https://a1.muscache.com/ac/pictures/65170901/6... | https://a1.muscache.com/im/pictures/65170901/6... | https://a1.muscache.com/ac/pictures/65170901/6... | https://a1.muscache.com/ac/pictures/65170901/6... | 25417834 | https://www.airbnb.com/users/show/25417834 | Markus And Melissa | 2014-12-31 | Seattle, Washington, United States | NaN | within an hour | 100% | 100% | t | https://a1.muscache.com/ac/users/25417834/prof... | https://a1.muscache.com/ac/users/25417834/prof... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | 12th Avenue West, Seattle, WA 98119, United St... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.640646 | -122.372406 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wireless Internet","Free Parking on Premises... | NaN | $99.00 | NaN | NaN | $100.00 | $15.00 | 1 | $0.00 | 2 | 14 | 2 weeks ago | t | 29 | 52 | 82 | 171 | 2016-01-04 | 45 | 2015-03-16 | 2015-11-06 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | t | moderate | f | f | 1 | 4.58 |
| 18 | 7735464 | https://www.airbnb.com/rooms/7735464 | 20160104002432 | 2016-01-04 | Queen Anne Getaway Near Seattle! | The second room in our spacious 2BR / 2 Bath a... | NaN | The second room in our spacious 2BR / 2 Bath a... | none | NaN | NaN | NaN | https://a2.muscache.com/ac/pictures/98338372/c... | https://a2.muscache.com/im/pictures/98338372/c... | https://a2.muscache.com/ac/pictures/98338372/c... | https://a2.muscache.com/ac/pictures/98338372/c... | 6170760 | https://www.airbnb.com/users/show/6170760 | Sam | 2013-04-30 | Seattle, Washington, United States | Sam | NaN | NaN | NaN | f | https://a2.muscache.com/ac/users/6170760/profi... | https://a2.muscache.com/ac/users/6170760/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'jum... | t | t | 11th Avenue West, Seattle, WA 98119, United St... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.639776 | -122.372235 | t | Apartment | Private room | 2 | 2.0 | 1.0 | 1.0 | Futon | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $200.00 | NaN | NaN | NaN | NaN | 1 | $0.00 | 1 | 1125 | 5 months ago | t | 0 | 0 | 0 | 125 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
| 19 | 6291829 | https://www.airbnb.com/rooms/6291829 | 20160104002432 | 2016-01-04 | Grand Craftsman Home on Queen Anne | This home built in 1909. It has 5 bedrooms a... | This home encompasses the character that is so... | This home built in 1909. It has 5 bedrooms a... | none | Upper Queen Anne is a charming neighborhood wi... | This is our family home that we choose to shar... | Easy bus access to all the sites: Lower Queen ... | NaN | NaN | https://a1.muscache.com/ac/pictures/78564472/f... | NaN | 32713558 | https://www.airbnb.com/users/show/32713558 | Kary | 2015-05-05 | Seattle, Washington, United States | My husband and I have 3 young adult children a... | NaN | NaN | NaN | f | https://a2.muscache.com/ac/users/32713558/prof... | https://a2.muscache.com/ac/users/32713558/prof... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'linkedin', 'reviews', 'kba'] | t | t | 1st Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.636025 | -122.358694 | t | House | Entire home/apt | 10 | 3.5 | 5.0 | 5.0 | Real Bed | {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... | NaN | $700.00 | $4,100.00 | NaN | $500.00 | $250.00 | 1 | $0.00 | 3 | 30 | 2 months ago | t | 24 | 54 | 84 | 359 | 2016-01-04 | 5 | 2015-07-07 | 2015-08-10 | 85.0 | 10.0 | 9.0 | 9.0 | 9.0 | 8.0 | 8.0 | f | NaN | WASHINGTON | f | flexible | f | f | 1 | 0.82 |
| 20 | 9218403 | https://www.airbnb.com/rooms/9218403 | 20160104002432 | 2016-01-04 | Queen Anne View One Bedroom | This clean and comfortable one bedroom sits ri... | Kitchen has hot water tap and sodastream Excel... | This clean and comfortable one bedroom sits ri... | none | Lower Queen Anne is near the Seattle Center (s... | NaN | NaN | https://a2.muscache.com/ac/pictures/6374cb3b-a... | https://a2.muscache.com/im/pictures/6374cb3b-a... | https://a2.muscache.com/ac/pictures/6374cb3b-a... | https://a2.muscache.com/ac/pictures/6374cb3b-a... | 14100483 | https://www.airbnb.com/users/show/14100483 | Annie | 2014-04-09 | Quilcene, Washington, United States | NaN | within a few hours | 100% | 100% | f | https://a0.muscache.com/ac/users/14100483/prof... | https://a0.muscache.com/ac/users/14100483/prof... | NaN | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | West Olympic Place, Seattle, WA 98119, United ... | NaN | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.627940 | -122.364959 | f | Condominium | Entire home/apt | 1 | 1.0 | 1.0 | 1.0 | Real Bed | {Internet,"Wireless Internet",Kitchen,"Free Pa... | NaN | $110.00 | $750.00 | $2,500.00 | NaN | NaN | 1 | $0.00 | 1 | 1125 | 4 weeks ago | t | 29 | 55 | 85 | 360 | 2016-01-04 | 1 | 2016-01-03 | 2016-01-03 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | flexible | f | f | 1 | 1.00 |
| 21 | 4125779 | https://www.airbnb.com/rooms/4125779 | 20160104002432 | 2016-01-04 | Cozy Queen Anne Finished Basement | Relax in your own private finished basement sp... | Updated daylight basement space with queen and... | Relax in your own private finished basement sp... | none | Just a few minutes walk to many great restaura... | Free parking. Queen Anne Farmers Market is on... | Metro Transit Bus #13 takes you to downtown Se... | https://a1.muscache.com/ac/pictures/52657137/d... | https://a1.muscache.com/im/pictures/52657137/d... | https://a1.muscache.com/ac/pictures/52657137/d... | https://a1.muscache.com/ac/pictures/52657137/d... | 21401856 | https://www.airbnb.com/users/show/21401856 | Nick | 2014-09-16 | Seattle, Washington, United States | I am a father, a devoted husband, a passionate... | within an hour | 100% | 100% | f | https://a1.muscache.com/ac/users/21401856/prof... | https://a1.muscache.com/ac/users/21401856/prof... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews'] | t | f | 2nd Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.636374 | -122.361033 | t | House | Private room | 3 | 1.5 | 1.0 | 2.0 | Real Bed | {"Cable TV",Internet,"Wireless Internet","Free... | NaN | $99.00 | $568.00 | $2,029.00 | NaN | $15.00 | 1 | $10.00 | 1 | 1125 | 2 months ago | t | 30 | 60 | 90 | 365 | 2016-01-04 | 11 | 2014-09-27 | 2015-10-18 | 84.0 | 9.0 | 9.0 | 9.0 | 9.0 | 10.0 | 8.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 0.71 |
| 22 | 8942678 | https://www.airbnb.com/rooms/8942678 | 20160104002432 | 2016-01-04 | Lovely Queen Anne home | Welcome to Seattle! Enjoy your stay in a turn... | Centrally located spacious home in the heart o... | Welcome to Seattle! Enjoy your stay in a turn... | none | Queen Anne is a wonderful mix of beautiful tre... | NaN | The bus stop is 3 blocks away. You are an easy... | NaN | NaN | https://a2.muscache.com/ac/pictures/c7e454ce-7... | NaN | 46675077 | https://www.airbnb.com/users/show/46675077 | Susanna | 2015-10-16 | Seattle, Washington, United States | NaN | within a day | 100% | 100% | f | https://a2.muscache.com/ac/pictures/facd36b6-c... | https://a2.muscache.com/ac/pictures/facd36b6-c... | Queen Anne | 1.0 | 1.0 | ['phone', 'reviews'] | t | f | 1st Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.635632 | -122.358881 | t | House | Entire home/apt | 8 | 2.0 | 4.0 | 4.0 | Real Bed | {TV,"Wireless Internet",Kitchen,"Free Parking ... | NaN | $450.00 | $3,000.00 | NaN | NaN | NaN | 1 | $0.00 | 4 | 1125 | 2 months ago | t | 0 | 0 | 0 | 53 | 2016-01-04 | 1 | 2015-12-01 | 2015-12-01 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | flexible | f | f | 1 | 0.86 |
| 23 | 10106055 | https://www.airbnb.com/rooms/10106055 | 20160104002432 | 2016-01-04 | Cozy Lower Level, Upper Queen Anne | Greetings! Our home is a beautiful, 1920's 4 ... | The space we are renting is the entire lower l... | Greetings! Our home is a beautiful, 1920's 4 ... | none | Queen Anne is a lovely and venerable Seattle n... | NaN | Our home is conveniently located within walkin... | https://a2.muscache.com/ac/pictures/3f11eb1a-3... | https://a2.muscache.com/im/pictures/3f11eb1a-3... | https://a2.muscache.com/ac/pictures/3f11eb1a-3... | https://a2.muscache.com/ac/pictures/3f11eb1a-3... | 51860756 | https://www.airbnb.com/users/show/51860756 | Maggie & Alex | 2015-12-20 | Seattle, Washington, United States | Hello! We're Maggie & Alex, and we are very ex... | NaN | NaN | NaN | f | https://a2.muscache.com/ac/pictures/11543d26-5... | https://a2.muscache.com/ac/pictures/11543d26-5... | Queen Anne | 1.0 | 1.0 | ['phone'] | t | f | West Galer Street, Seattle, WA 98119, United S... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.633394 | -122.371920 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {Internet,"Wireless Internet","Air Conditionin... | NaN | $75.00 | $350.00 | NaN | NaN | NaN | 1 | $0.00 | 1 | 1125 | today | t | 30 | 60 | 90 | 365 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
| 24 | 6362362 | https://www.airbnb.com/rooms/6362362 | 20160104002432 | 2016-01-04 | Charming home on Queen Anne | Enjoy Seattle from the ideally located Queen A... | Step into the main living space with sitting a... | Enjoy Seattle from the ideally located Queen A... | none | NaN | There is plenty of street parking and one desi... | 10th Avenue West is on the bus line taking you... | NaN | NaN | https://a1.muscache.com/ac/pictures/79617550/d... | NaN | 33147763 | https://www.airbnb.com/users/show/33147763 | Tracy | 2015-05-11 | Seattle, Washington, United States | NaN | NaN | NaN | NaN | f | https://a1.muscache.com/ac/users/33147763/prof... | https://a1.muscache.com/ac/users/33147763/prof... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'reviews'] | t | f | 10th Avenue West, Seattle, WA 98119, United St... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.638517 | -122.369581 | t | House | Entire home/apt | 5 | 2.5 | 3.0 | 3.0 | Real Bed | {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... | NaN | $600.00 | NaN | NaN | $500.00 | $150.00 | 1 | $0.00 | 3 | 1125 | 3 months ago | t | 0 | 0 | 0 | 212 | 2016-01-04 | 1 | 2015-07-20 | 2015-07-20 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 0.18 |
| 25 | 3544550 | https://www.airbnb.com/rooms/3544550 | 20160104002432 | 2016-01-04 | VIEW-Monthly Rental Available | Our home is very light and full of character a... | Our home is a brick tudor/cottage built in 193... | Our home is very light and full of character a... | none | Upper Queen Anne is a charming neighborhood fu... | Our house is located just 5 short blocks to To... | A bus stop is just 2 blocks away. Easy bus a... | NaN | NaN | https://a1.muscache.com/ac/pictures/44791979/6... | NaN | 16708587 | https://www.airbnb.com/users/show/16708587 | Jill | 2014-06-12 | Seattle, Washington, United States | i love living in Seattle. i grew up in the mi... | within a few hours | 67% | 100% | f | https://a1.muscache.com/ac/users/16708587/prof... | https://a1.muscache.com/ac/users/16708587/prof... | Queen Anne | 2.0 | 2.0 | ['email', 'phone', 'google', 'reviews', 'jumio'] | t | t | 7th Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.631397 | -122.367767 | t | House | Entire home/apt | 8 | 2.5 | 3.0 | 5.0 | Real Bed | {TV,"Cable TV","Wireless Internet","Air Condit... | NaN | $450.00 | NaN | NaN | $500.00 | $200.00 | 6 | $50.00 | 4 | 1125 | today | t | 0 | 3 | 33 | 293 | 2016-01-04 | 8 | 2015-07-04 | 2015-09-02 | 100.0 | 10.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 2 | 1.30 |
| 26 | 9025039 | https://www.airbnb.com/rooms/9025039 | 20160104002432 | 2016-01-04 | Cute Bungalow-Close to Everything! | Our cozy little bungalow is the perfect place ... | One bedroom has a queen sized bed, and the oth... | Our cozy little bungalow is the perfect place ... | none | The Queen Anne neighborhood is one of the most... | The Queen Anne neighborhood is one of the most... | There are several bus routes a few short steps... | NaN | NaN | https://a2.muscache.com/ac/pictures/21a1c1e1-f... | NaN | 68155 | https://www.airbnb.com/users/show/68155 | Lori | 2010-01-06 | Seattle, Washington, United States | Mom to two young boys, writer, real estate bro... | within a few hours | 100% | 100% | f | https://a2.muscache.com/ac/users/68155/profile... | https://a2.muscache.com/ac/users/68155/profile... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'jum... | t | t | West McGraw Street, Seattle, WA 98119, United ... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.638752 | -122.367973 | t | House | Entire home/apt | 5 | 1.0 | 2.0 | 3.0 | Real Bed | {"Cable TV","Wireless Internet",Kitchen,"Free ... | NaN | $150.00 | NaN | NaN | $250.00 | $35.00 | 1 | $0.00 | 1 | 1125 | 3 days ago | t | 0 | 0 | 0 | 49 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
| 27 | 3200646 | https://www.airbnb.com/rooms/3200646 | 20160104002432 | 2016-01-04 | Micro Gypsy Wagon on Queen Anne | Micro camper with queen size bed and seating f... | The Spruce Kaboose is a hand built one of a ki... | Micro camper with queen size bed and seating f... | none | Interbay is right between downtown Seattle and... | There are THREE rentals in our yard . If your ... | We are on the D bus line. If you are busing f... | https://a0.muscache.com/ac/pictures/67216372/d... | https://a0.muscache.com/im/pictures/67216372/d... | https://a0.muscache.com/ac/pictures/67216372/d... | https://a0.muscache.com/ac/pictures/67216372/d... | 4016632 | https://www.airbnb.com/users/show/4016632 | Jean-Marc | 2012-10-30 | Seattle, Washington, United States | I am a carpenter at heart , I love music , I p... | within an hour | 100% | 100% | t | https://a1.muscache.com/ac/users/4016632/profi... | https://a1.muscache.com/ac/users/4016632/profi... | Queen Anne | 5.0 | 5.0 | ['email', 'phone', 'facebook', 'google', 'link... | t | t | West Wheeler Street, Seattle, WA 98119, United... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.639266 | -122.374726 | t | Camper/RV | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wireless Internet","Pets live on this proper... | NaN | $45.00 | $360.00 | NaN | $150.00 | $25.00 | 1 | $0.00 | 2 | 7 | yesterday | t | 22 | 49 | 49 | 107 | 2016-01-04 | 80 | 2014-07-06 | 2016-01-02 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 9.0 | f | NaN | WASHINGTON | f | strict | t | t | 5 | 4.38 |
| 28 | 8859380 | https://www.airbnb.com/rooms/8859380 | 20160104002432 | 2016-01-04 | STUNNING VIEW of Puget Sound | This three bedroom flat is your gorgeous retre... | You won't want to leave your home away from ho... | This three bedroom flat is your gorgeous retre... | none | Located in the beautiful neighborhood of Queen... | NaN | You have on-site parking if you have a car. If... | NaN | NaN | https://a2.muscache.com/ac/pictures/ed5b5e7c-7... | NaN | 3792761 | https://www.airbnb.com/users/show/3792761 | Kimberly | 2012-10-07 | Seattle, Washington, United States | I am from Seattle WA, and I love to travel! \r... | within an hour | 100% | 100% | f | https://a2.muscache.com/ac/pictures/15d8ced5-c... | https://a2.muscache.com/ac/pictures/15d8ced5-c... | Queen Anne | 5.0 | 5.0 | ['email', 'phone', 'reviews', 'jumio', 'kba'] | t | t | 9th Avenue West, Seattle, WA 98119, United States | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.629907 | -122.368948 | t | Apartment | Entire home/apt | 6 | 2.0 | 3.0 | 3.0 | Real Bed | {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... | NaN | $300.00 | NaN | NaN | $500.00 | $125.00 | 1 | $0.00 | 2 | 1125 | 4 days ago | t | 24 | 54 | 84 | 356 | 2016-01-04 | 6 | 2015-10-24 | 2016-01-02 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | t | moderate | f | f | 1 | 2.47 |
| 29 | 4520099 | https://www.airbnb.com/rooms/4520099 | 20160104002432 | 2016-01-04 | Open Airy Queen Anne Condo | Designer home situated on Queen Anne Hill over... | During the summer, there was construction on t... | Designer home situated on Queen Anne Hill over... | none | This is a really quiet neighborhood with plent... | My neighbors are really quiet and the condo do... | There is a very convenient bus line a block aw... | https://a0.muscache.com/ac/pictures/60875300/3... | https://a0.muscache.com/im/pictures/60875300/3... | https://a0.muscache.com/ac/pictures/60875300/3... | https://a0.muscache.com/ac/pictures/60875300/3... | 6184895 | https://www.airbnb.com/users/show/6184895 | Lana | 2013-05-01 | Seattle, Washington, United States | NaN | within an hour | 71% | 100% | f | https://a1.muscache.com/ac/users/6184895/profi... | https://a1.muscache.com/ac/users/6184895/profi... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | 14th Avenue West, Seattle, WA 98119, United St... | Queen Anne | West Queen Anne | Queen Anne | Seattle | WA | 98119 | Seattle | Seattle, WA | US | United States | 47.639816 | -122.374338 | t | Apartment | Entire home/apt | 3 | 1.0 | 1.0 | 2.0 | Real Bed | {TV,"Cable TV","Wireless Internet","Wheelchair... | NaN | $80.00 | $500.00 | NaN | NaN | $65.00 | 3 | $50.00 | 2 | 1125 | 5 days ago | t | 0 | 1 | 30 | 305 | 2016-01-04 | 4 | 2015-01-04 | 2015-07-25 | 85.0 | 8.0 | 9.0 | 7.0 | 10.0 | 9.0 | 9.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 0.33 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 3788 | 7745196 | https://www.airbnb.com/rooms/7745196 | 20160104002432 | 2016-01-04 | Cozy Modern Apartment in Fremont | Our apartment is bright and airy and a modern ... | Our apartment is brand new construction with t... | Our apartment is bright and airy and a modern ... | none | The Fremont neighborhood of Seattle is known a... | We strive to stay competitive on rates while o... | It's easy to get around Seattle from our neigh... | https://a2.muscache.com/ac/pictures/102889373/... | https://a2.muscache.com/im/pictures/102889373/... | https://a2.muscache.com/ac/pictures/102889373/... | https://a2.muscache.com/ac/pictures/102889373/... | 398005 | https://www.airbnb.com/users/show/398005 | Trevor | 2011-02-18 | Seattle, Washington, United States | I'm from Seattle, WA, where I live with the lo... | within an hour | 100% | 100% | f | https://a0.muscache.com/ac/users/398005/profil... | https://a0.muscache.com/ac/users/398005/profil... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'google', 'reviews', 'kba'] | t | t | Woodland Park Avenue North, Seattle, WA 98103,... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.656739 | -122.344865 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 2.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,Heati... | NaN | $115.00 | $850.00 | $3,240.00 | $199.00 | $60.00 | 2 | $12.00 | 1 | 1125 | 2 weeks ago | t | 20 | 46 | 76 | 347 | 2016-01-04 | 14 | 2015-09-03 | 2015-12-20 | 99.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 3.39 |
| 3789 | 4645405 | https://www.airbnb.com/rooms/4645405 | 20160104002432 | 2016-01-04 | Private light, minimalist room | The extremely comfortable sleep number Califor... | Vintage, modern 1910 craftsman with dark expos... | The extremely comfortable sleep number Califor... | none | I love that I can walk 15 minutes into Fremont... | Check in: 6pm Check out: 10am There is a lock... | Walk Score :Very Walkable Transit Score: Good ... | https://a2.muscache.com/ac/pictures/109434352/... | https://a2.muscache.com/im/pictures/109434352/... | https://a2.muscache.com/ac/pictures/109434352/... | https://a2.muscache.com/ac/pictures/109434352/... | 13771267 | https://www.airbnb.com/users/show/13771267 | Paige | 2014-04-01 | Seattle, Washington, United States | I am a freelance photographer born and raised ... | within a few hours | 100% | 100% | f | https://a1.muscache.com/ac/users/13771267/prof... | https://a1.muscache.com/ac/users/13771267/prof... | Fremont | 2.0 | 2.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | North 46th Street, Seattle, WA 98103, United S... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.661171 | -122.349923 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,Heati... | NaN | $60.00 | $500.00 | $1,500.00 | NaN | $10.00 | 2 | $25.00 | 1 | 14 | today | t | 28 | 54 | 84 | 359 | 2016-01-04 | 23 | 2015-02-17 | 2015-11-28 | 90.0 | 9.0 | 9.0 | 9.0 | 10.0 | 9.0 | 9.0 | f | NaN | WASHINGTON | f | flexible | f | f | 2 | 2.14 |
| 3790 | 2755730 | https://www.airbnb.com/rooms/2755730 | 20160104002432 | 2016-01-04 | Your own 2 Bedroom home in Fremont | Private 2 bedroom retreat in the heart of Frem... | The house was built in 1906 by the Seattle Lum... | Private 2 bedroom retreat in the heart of Frem... | none | Very walkable, with lots of bike lanes and qui... | NaN | Metro transit lines are one block away with di... | https://a1.muscache.com/ac/pictures/40919375/2... | https://a1.muscache.com/im/pictures/40919375/2... | https://a1.muscache.com/ac/pictures/40919375/2... | https://a1.muscache.com/ac/pictures/40919375/2... | 3752499 | https://www.airbnb.com/users/show/3752499 | Donna | 2012-10-04 | Seattle, Washington, United States | I am so proud to have converted the first floo... | within an hour | 100% | 100% | t | https://a2.muscache.com/ac/users/3752499/profi... | https://a2.muscache.com/ac/users/3752499/profi... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | North 35th Street, Seattle, WA 98103, United S... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.649271 | -122.347817 | t | Apartment | Entire home/apt | 6 | 1.0 | 2.0 | 3.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,"Pets... | NaN | $175.00 | NaN | NaN | $250.00 | $50.00 | 4 | $30.00 | 2 | 29 | today | t | 18 | 48 | 78 | 335 | 2016-01-04 | 75 | 2014-05-18 | 2015-12-14 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | t | strict | f | f | 1 | 3.77 |
| 3791 | 7949448 | https://www.airbnb.com/rooms/7949448 | 20160104002432 | 2016-01-04 | Private Suite in Fremont-Ballard | This is a private suite with bedroom and bathr... | This is a ground floor bedroom in our townhous... | This is a private suite with bedroom and bathr... | none | Our house is centrally located between Ballard... | Parking There is adequate free parking on the ... | BUS LINES The house is close to bus lines tha... | https://a1.muscache.com/ac/pictures/101354275/... | https://a1.muscache.com/im/pictures/101354275/... | https://a1.muscache.com/ac/pictures/101354275/... | https://a1.muscache.com/ac/pictures/101354275/... | 26392625 | https://www.airbnb.com/users/show/26392625 | Jason | 2015-01-20 | Seattle, Washington, United States | My name is Jason and my wife is Keri. We have... | within a few hours | 100% | 100% | f | https://a0.muscache.com/ac/users/26392625/prof... | https://a0.muscache.com/ac/users/26392625/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'linkedin', 'reviews', 'kba'] | t | t | 6th Avenue Northwest, Seattle, WA 98107, Unite... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.659149 | -122.363466 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","F... | NaN | $85.00 | $600.00 | $2,250.00 | $100.00 | $40.00 | 1 | $0.00 | 2 | 30 | 4 days ago | t | 29 | 59 | 89 | 178 | 2016-01-04 | 11 | 2015-08-25 | 2015-11-28 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 2.48 |
| 3792 | 9288840 | https://www.airbnb.com/rooms/9288840 | 20160104002432 | 2016-01-04 | City Haven | Vacationing in Seattle? Traveling for business... | NaN | Vacationing in Seattle? Traveling for business... | none | NaN | NaN | NaN | https://a2.muscache.com/ac/pictures/40835954-c... | https://a2.muscache.com/im/pictures/40835954-c... | https://a2.muscache.com/ac/pictures/40835954-c... | https://a2.muscache.com/ac/pictures/40835954-c... | 15784748 | https://www.airbnb.com/users/show/15784748 | Teresa | 2014-05-20 | Seattle, Washington, United States | NaN | within an hour | 100% | NaN | f | https://a2.muscache.com/ac/pictures/34a8914a-2... | https://a2.muscache.com/ac/pictures/34a8914a-2... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'kba'] | t | f | North 46th Street, Seattle, WA 98103, United S... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.663040 | -122.348499 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $109.00 | NaN | NaN | $200.00 | $45.00 | 1 | $0.00 | 2 | 1125 | 5 days ago | t | 0 | 0 | 0 | 34 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
| 3793 | 3312406 | https://www.airbnb.com/rooms/3312406 | 20160104002432 | 2016-01-04 | Seattle Urban-Chic Studio Cottage | Come stay at this 2014 Northwest Green Home To... | Private, just-built, high-end studio loft in a... | Come stay at this 2014 Northwest Green Home To... | none | Renowned restaurants, coffeshops and bars, the... | We occasionally have friends over for evening ... | Super convenient to EVERYTHING and all the bes... | NaN | NaN | https://a1.muscache.com/ac/pictures/54326594/8... | NaN | 16727906 | https://www.airbnb.com/users/show/16727906 | Tory | 2014-06-13 | Seattle, Washington, United States | My husband, Adam, and I, live in the main hous... | within an hour | 100% | 100% | t | https://a0.muscache.com/ac/users/16727906/prof... | https://a0.muscache.com/ac/users/16727906/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | Baker Avenue Northwest, Seattle, WA 98107, Uni... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.660056 | -122.357683 | t | House | Entire home/apt | 4 | 1.0 | 0.0 | 2.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $109.00 | $725.00 | $2,895.00 | $200.00 | $55.00 | 4 | $30.00 | 2 | 180 | today | t | 17 | 44 | 66 | 341 | 2016-01-04 | 78 | 2014-07-07 | 2015-12-30 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | t | strict | f | f | 1 | 4.28 |
| 3794 | 6621924 | https://www.airbnb.com/rooms/6621924 | 20160104002432 | 2016-01-04 | Hazel Heights Hideout | An one-bedroom apartment in the top level of m... | Enter via the big back deck which has views of... | An one-bedroom apartment in the top level of m... | none | Fremont - The Center Of The Universe. This ne... | My neighborhood is a residential neighborhood,... | Walking distance to Fremont, which has tons of... | https://a1.muscache.com/ac/pictures/85686578/1... | https://a1.muscache.com/im/pictures/85686578/1... | https://a1.muscache.com/ac/pictures/85686578/1... | https://a1.muscache.com/ac/pictures/85686578/1... | 30049045 | https://www.airbnb.com/users/show/30049045 | Tim And Amanda | 2015-03-26 | Seattle, Washington, United States | Passionate travelers and hosts! We hope you do... | within a few hours | 80% | 100% | f | https://a2.muscache.com/ac/users/30049045/prof... | https://a2.muscache.com/ac/users/30049045/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'jumio'] | t | t | Northwest Bowdoin Place, Seattle, WA 98107, Un... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.654199 | -122.359987 | t | Apartment | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wireless Internet",Kitchen,Heating,"Smoke De... | NaN | $107.00 | $1,000.00 | $3,633.00 | NaN | $40.00 | 2 | $30.00 | 2 | 1125 | 2 months ago | t | 30 | 60 | 89 | 89 | 2016-01-04 | 21 | 2015-06-16 | 2015-12-15 | 90.0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 8.0 | f | NaN | WASHINGTON | f | flexible | f | f | 1 | 3.10 |
| 3795 | 5673552 | https://www.airbnb.com/rooms/5673552 | 20160104002432 | 2016-01-04 | Beautiful loft in downtown Fremont | Our cool loft apartment offers a convenient lo... | This historic building houses a converted stor... | Our cool loft apartment offers a convenient lo... | none | Fremont is a unique, young neighborhood filled... | Since the apartment is right on the streets of... | Easily accessible from the SeaTac Airport by b... | https://a2.muscache.com/ac/pictures/73308107/f... | https://a2.muscache.com/im/pictures/73308107/f... | https://a2.muscache.com/ac/pictures/73308107/f... | https://a2.muscache.com/ac/pictures/73308107/f... | 28007250 | https://www.airbnb.com/users/show/28007250 | Brittney | 2015-02-19 | Seattle, Washington, United States | Working for Brooks Sports, love living in Seat... | within an hour | 100% | 100% | t | https://a1.muscache.com/ac/users/28007250/prof... | https://a1.muscache.com/ac/users/28007250/prof... | NaN | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'jum... | t | t | Woodland Park Ave N, Seattle, WA 98103, United... | NaN | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.650124 | -122.343283 | f | Loft | Entire home/apt | 4 | 1.0 | 0.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $200.00 | NaN | NaN | NaN | $40.00 | 1 | $0.00 | 2 | 1125 | 3 months ago | t | 2 | 2 | 2 | 265 | 2016-01-04 | 10 | 2015-04-26 | 2015-10-24 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | flexible | f | f | 1 | 1.18 |
| 3796 | 609701 | https://www.airbnb.com/rooms/609701 | 20160104002432 | 2016-01-04 | Charming Fremont Garden Cottage | Enjoy the excitement of Seattle and city life ... | Charming and pristine pied-a-terre in the mids... | Enjoy the excitement of Seattle and city life ... | none | FREMONT is such a fun neighborhood with lot's ... | Street parking is usually plentiful so help yo... | NaN | https://a2.muscache.com/ac/pictures/8157091/5a... | https://a2.muscache.com/im/pictures/8157091/5a... | https://a2.muscache.com/ac/pictures/8157091/5a... | https://a2.muscache.com/ac/pictures/8157091/5a... | 3023407 | https://www.airbnb.com/users/show/3023407 | Nan | 2012-07-23 | Seattle, Washington, United States | I'm a native Northwesterner and love to travel... | within an hour | 100% | 100% | t | https://a0.muscache.com/ac/users/3023407/profi... | https://a0.muscache.com/ac/users/3023407/profi... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'jumio'] | t | t | NW 40th St, Seattle, WA 98107, United States | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.656508 | -122.360571 | t | Cabin | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV","Wireless Internet",Kitchen,"Fr... | NaN | $85.00 | NaN | NaN | NaN | $20.00 | 1 | $0.00 | 2 | 30 | yesterday | t | 25 | 48 | 75 | 307 | 2016-01-04 | 233 | 2012-07-29 | 2015-12-31 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | t | moderate | f | f | 1 | 5.57 |
| 3797 | 10118341 | https://www.airbnb.com/rooms/10118341 | 20160104002432 | 2016-01-04 | Fremont Lighthouse Mother-in-Law | A clean and simple mother-in-law across the st... | A clean and simple mother-in-law basement stud... | A clean and simple mother-in-law across the st... | none | Located at the top of Fremont neighborhood/up ... | NaN | NaN | https://a2.muscache.com/ac/pictures/8cf79670-c... | https://a2.muscache.com/im/pictures/8cf79670-c... | https://a2.muscache.com/ac/pictures/8cf79670-c... | https://a2.muscache.com/ac/pictures/8cf79670-c... | 1237248 | https://www.airbnb.com/users/show/1237248 | Elise | 2011-10-02 | Seattle, Washington, United States | Technology Marketing professional, likes outdo... | within an hour | 100% | 100% | f | https://a0.muscache.com/ac/users/1237248/profi... | https://a0.muscache.com/ac/users/1237248/profi... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'linkedin', 'reviews', 'kba'] | t | t | Phinney Avenue North, Seattle, WA 98103, Unite... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.658976 | -122.354915 | t | House | Entire home/apt | 2 | 1.0 | 0.0 | 1.0 | Futon | {"Wireless Internet",Kitchen,Heating,Washer,Dr... | NaN | $70.00 | NaN | NaN | $200.00 | NaN | 2 | $20.00 | 3 | 1125 | yesterday | t | 2 | 2 | 2 | 2 | 2016-01-04 | 1 | 2016-01-02 | 2016-01-02 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 1.00 |
| 3798 | 2614387 | https://www.airbnb.com/rooms/2614387 | 20160104002432 | 2016-01-04 | Everything Seattle in 0-3 miles, A | Spacious 1 bedroom: private 3/4 bathroom, Quee... | New, modern, clean, quiet and no clutter, yet ... | Spacious 1 bedroom: private 3/4 bathroom, Quee... | none | I love everything about my neighborhood, Seatt... | A few blocks from the house is Manolin Seafood... | Free on-street parking. Easy public transit. B... | https://a0.muscache.com/ac/pictures/63200945/a... | https://a0.muscache.com/im/pictures/63200945/a... | https://a0.muscache.com/ac/pictures/63200945/a... | https://a0.muscache.com/ac/pictures/63200945/a... | 1123549 | https://www.airbnb.com/users/show/1123549 | Sandy | 2011-09-07 | Seattle, Washington, United States | Hello,\r\nI like the airbnb concept because I ... | within an hour | 100% | 100% | f | https://a0.muscache.com/ac/users/1123549/profi... | https://a0.muscache.com/ac/users/1123549/profi... | Fremont | 2.0 | 2.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | Midvale Avenue North, Seattle, WA 98103, Unite... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.655381 | -122.343205 | t | House | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,"Free... | NaN | $77.00 | $499.00 | NaN | NaN | $15.00 | 2 | $15.00 | 2 | 14 | a week ago | t | 19 | 42 | 72 | 338 | 2016-01-04 | 128 | 2014-03-31 | 2015-12-31 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 2 | 5.95 |
| 3799 | 7735100 | https://www.airbnb.com/rooms/7735100 | 20160104002432 | 2016-01-04 | Master bedroom in Fremont | The townhouse is conveniently blocks away from... | NaN | The townhouse is conveniently blocks away from... | none | NaN | NaN | NaN | NaN | NaN | https://a1.muscache.com/ac/pictures/98338478/f... | NaN | 7227474 | https://www.airbnb.com/users/show/7227474 | Roger | 2013-07-01 | Seattle, Washington, United States | Hi! I've spent my whole life on the west coast... | a few days or more | 25% | 100% | f | https://a0.muscache.com/ac/users/7227474/profi... | https://a0.muscache.com/ac/users/7227474/profi... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | Dayton Avenue North, Seattle, WA 98103, United... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.652902 | -122.352110 | t | Townhouse | Private room | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,"Free... | NaN | $65.00 | $375.00 | $1,400.00 | $150.00 | $25.00 | 1 | $0.00 | 2 | 1125 | 2 weeks ago | t | 6 | 6 | 6 | 269 | 2016-01-04 | 5 | 2015-08-16 | 2015-12-25 | 95.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 1.06 |
| 3800 | 5482204 | https://www.airbnb.com/rooms/5482204 | 20160104002432 | 2016-01-04 | Six room suite | Seattle's most elegant and romantic lit... | Each suite is 900 square feet of luxury and el... | Seattle's most elegant and romantic lit... | none | Chelsea Station Inn is walking distance to the... | Each suite's kitchen is coffee ready with Nesp... | Super easy by bus or driving ! | https://a1.muscache.com/ac/pictures/69724382/f... | https://a1.muscache.com/im/pictures/69724382/f... | https://a1.muscache.com/ac/pictures/69724382/f... | https://a1.muscache.com/ac/pictures/69724382/f... | 28432113 | https://www.airbnb.com/users/show/28432113 | Chelsea Station Inn | 2015-02-27 | Seattle, Washington, United States | Seattle's most elegant and romantic little Inn... | NaN | NaN | NaN | f | https://a2.muscache.com/ac/users/28432113/prof... | https://a2.muscache.com/ac/users/28432113/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone'] | t | f | Linden Avenue North, Seattle, WA 98103, United... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.663613 | -122.349519 | t | Bed & Breakfast | Private room | 2 | 1.5 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $185.00 | NaN | NaN | NaN | NaN | 1 | $0.00 | 1 | 1125 | 10 months ago | t | 0 | 0 | 0 | 275 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | strict | f | f | 1 | NaN |
| 3801 | 4524575 | https://www.airbnb.com/rooms/4524575 | 20160104002432 | 2016-01-04 | Comfortable Fremont Apartment | This lovely apartment is located on the lower ... | Our recently renovated apartment is perfect fo... | This lovely apartment is located on the lower ... | none | Fremont is centrally located within the city a... | NaN | 4 blocks to the #5 bus stop, providing a >20 m... | https://a1.muscache.com/ac/pictures/56811707/6... | https://a1.muscache.com/im/pictures/56811707/6... | https://a1.muscache.com/ac/pictures/56811707/6... | https://a1.muscache.com/ac/pictures/56811707/6... | 20853099 | https://www.airbnb.com/users/show/20853099 | Flora | 2014-09-02 | Seattle, Washington, United States | I love family, community, people, culture, art... | within a few hours | 100% | 100% | t | https://a1.muscache.com/ac/users/20853099/prof... | https://a1.muscache.com/ac/users/20853099/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'linkedin', 'reviews', 'kba'] | t | t | 1st Avenue Northwest, Seattle, WA 98107, Unite... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.657078 | -122.358795 | t | Apartment | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $108.00 | $700.00 | $2,500.00 | $200.00 | $45.00 | 2 | $10.00 | 4 | 1125 | a week ago | t | 30 | 56 | 85 | 85 | 2016-01-04 | 28 | 2014-11-21 | 2015-12-10 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 2.05 |
| 3802 | 8562314 | https://www.airbnb.com/rooms/8562314 | 20160104002432 | 2016-01-04 | Cozy Craftsman in Heart of Fremont | Our rare for its location, 2 bedroom and 1 bat... | In a land ruled by condos, it's hard to find a... | Our rare for its location, 2 bedroom and 1 bat... | none | I loved living here before we had 3 kids. The ... | Please no parties or large groups at our home.... | There is a bus stop on the corner of the stree... | https://a0.muscache.com/ac/pictures/108784666/... | https://a0.muscache.com/im/pictures/108784666/... | https://a0.muscache.com/ac/pictures/108784666/... | https://a0.muscache.com/ac/pictures/108784666/... | 18774473 | https://www.airbnb.com/users/show/18774473 | Victoria | 2014-07-23 | US | NaN | NaN | NaN | NaN | f | https://a2.muscache.com/ac/pictures/9de2d88b-0... | https://a2.muscache.com/ac/pictures/9de2d88b-0... | NaN | 1.0 | 1.0 | ['email', 'phone'] | t | f | North 35th Street, Seattle, WA 98103, United S... | NaN | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.650765 | -122.347787 | f | House | Entire home/apt | 4 | 1.0 | 2.0 | 2.0 | Real Bed | {TV,"Wireless Internet",Kitchen,"Pets Allowed"... | NaN | $200.00 | $1,300.00 | $5,400.00 | NaN | NaN | 1 | $0.00 | 2 | 1125 | 3 months ago | t | 0 | 0 | 0 | 247 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
| 3803 | 9698202 | https://www.airbnb.com/rooms/9698202 | 20160104002432 | 2016-01-04 | Clean City House, Lots of Beds | Get anywhere in Seattle quickly from this grea... | The space is well suited for large groups and ... | Get anywhere in Seattle quickly from this grea... | none | This house is central to any neighborhood you'... | NaN | Bus lines galore! If you want to use public tr... | https://a2.muscache.com/ac/pictures/60f3d68d-f... | https://a2.muscache.com/im/pictures/60f3d68d-f... | https://a2.muscache.com/ac/pictures/60f3d68d-f... | https://a2.muscache.com/ac/pictures/60f3d68d-f... | 5325329 | https://www.airbnb.com/users/show/5325329 | Blair | 2013-03-04 | Seattle, Washington, United States | My name is Blair and I'm glad you are interest... | within a few hours | 97% | 100% | f | https://a0.muscache.com/ac/users/5325329/profi... | https://a0.muscache.com/ac/users/5325329/profi... | Queen Anne | 9.0 | 9.0 | ['email', 'phone', 'facebook', 'linkedin', 're... | t | t | Linden Avenue North, Seattle, WA 98103, United... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.661131 | -122.349238 | t | House | Entire home/apt | 16 | 3.5 | 4.0 | 10.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,"Free... | NaN | $250.00 | NaN | NaN | $250.00 | $100.00 | 12 | $25.00 | 1 | 1125 | today | t | 25 | 51 | 72 | 328 | 2016-01-04 | 4 | 2015-12-14 | 2016-01-01 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 8 | 4.00 |
| 3804 | 7178490 | https://www.airbnb.com/rooms/7178490 | 20160104002432 | 2016-01-04 | Cedar House Studio Suite in Fremont | Comfortable and clean, this lower level suite ... | A lush, private garden path leads to the entra... | Comfortable and clean, this lower level suite ... | none | Upper Fremont is a vibrant neighborhood that o... | There is a second staircase that leads to our ... | This apartment is centrally located amongst th... | https://a2.muscache.com/ac/pictures/91338809/e... | https://a2.muscache.com/im/pictures/91338809/e... | https://a2.muscache.com/ac/pictures/91338809/e... | https://a2.muscache.com/ac/pictures/91338809/e... | 566102 | https://www.airbnb.com/users/show/566102 | Eve | 2011-05-07 | Seattle, Washington, United States | Seattle, WA | within a few hours | 100% | 100% | t | https://a1.muscache.com/ac/users/566102/profil... | https://a1.muscache.com/ac/users/566102/profil... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | N 44th st, Seattle, WA 98103, United States | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.660856 | -122.352401 | t | Apartment | Entire home/apt | 2 | 1.0 | 0.0 | 1.0 | Real Bed | {TV,Internet,"Wireless Internet",Kitchen,Heati... | NaN | $125.00 | $888.00 | NaN | $150.00 | $45.00 | 1 | $0.00 | 2 | 1125 | 3 weeks ago | t | 23 | 53 | 83 | 358 | 2016-01-04 | 12 | 2015-08-04 | 2015-11-29 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 2.34 |
| 3805 | 8054902 | https://www.airbnb.com/rooms/8054902 | 20160104002432 | 2016-01-04 | 2 BR/1 BA Fremont Apt w/ parking | This 2 bedroom, 1 bath garden-level apartment ... | The Space This 2 bedroom, 1 bath garden-level ... | This 2 bedroom, 1 bath garden-level apartment ... | none | One of the most fun neighborhoods in Seattle. ... | This apartment is located directly below our 1... | Fremont is a great location for visitors looki... | https://a1.muscache.com/ac/pictures/110078306/... | https://a1.muscache.com/im/pictures/110078306/... | https://a1.muscache.com/ac/pictures/110078306/... | https://a1.muscache.com/ac/pictures/110078306/... | 4071088 | https://www.airbnb.com/users/show/4071088 | David | 2012-11-05 | Seattle, Washington, United States | Hi! My name is David and I currently live in ... | within an hour | 100% | 100% | f | https://a0.muscache.com/ac/users/4071088/profi... | https://a0.muscache.com/ac/users/4071088/profi... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'linkedin', 're... | t | t | 1st Avenue Northwest, Seattle, WA 98107, Unite... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.653158 | -122.356285 | t | Apartment | Entire home/apt | 6 | 1.0 | 2.0 | 2.0 | Real Bed | {TV,Internet,"Wireless Internet","Air Conditio... | NaN | $100.00 | NaN | NaN | $200.00 | $89.00 | 4 | $20.00 | 2 | 30 | today | t | 19 | 49 | 79 | 329 | 2016-01-04 | 10 | 2015-10-21 | 2015-12-23 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 3.95 |
| 3806 | 5458027 | https://www.airbnb.com/rooms/5458027 | 20160104002432 | 2016-01-04 | Sunny Charm in Urban Cottage 2BD | Charming urban home with rustic cottage feel. ... | NaN | Charming urban home with rustic cottage feel. ... | none | NaN | Deb, the cleaning lady & caretaker, will be in... | NaN | NaN | NaN | https://a2.muscache.com/ac/pictures/101952566/... | NaN | 6963318 | https://www.airbnb.com/users/show/6963318 | Grace | 2013-06-17 | Seattle, Washington, United States | Welcome to Fremont!\n\nI look forward to hosti... | within an hour | 100% | 100% | t | https://a2.muscache.com/ac/users/6963318/profi... | https://a2.muscache.com/ac/users/6963318/profi... | Fremont | 2.0 | 2.0 | ['email', 'phone', 'reviews', 'jumio'] | t | t | Greenwood Avenue North, Seattle, WA 98103, Uni... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.656057 | -122.354514 | t | House | Entire home/apt | 4 | 1.0 | 2.0 | 2.0 | Real Bed | {Internet,"Wireless Internet",Kitchen,Heating,... | NaN | $160.00 | NaN | NaN | NaN | $50.00 | 1 | $0.00 | 1 | 1125 | 3 months ago | t | 0 | 0 | 0 | 109 | 2016-01-04 | 1 | 2015-08-31 | 2015-08-31 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | flexible | f | f | 2 | 0.24 |
| 3807 | 4940491 | https://www.airbnb.com/rooms/4940491 | 20160104002432 | 2016-01-04 | Roof Deck in Fremont/Wallingford | Adorable private studio nestled in one of Seat... | The studio is filled with beautiful original a... | Adorable private studio nestled in one of Seat... | none | From the apartment it is an easy walk to the h... | NaN | Public Bus stops right outside the building. | NaN | NaN | https://a2.muscache.com/ac/pictures/63461830/1... | NaN | 466499 | https://www.airbnb.com/users/show/466499 | Elizabeth | 2011-03-27 | Arlington, Massachusetts, United States | Until last year, I lived in the Boston area, b... | within a day | 100% | 100% | f | https://a0.muscache.com/ac/users/466499/profil... | https://a0.muscache.com/ac/users/466499/profil... | Wallingford | 1.0 | 1.0 | ['email', 'phone', 'reviews'] | t | f | Stone Way North, Seattle, WA 98103, United States | Wallingford | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.654304 | -122.342720 | t | Apartment | Entire home/apt | 2 | 1.0 | 0.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $109.00 | NaN | $1,800.00 | NaN | $25.00 | 2 | $0.00 | 1 | 360 | 4 days ago | t | 4 | 21 | 51 | 325 | 2016-01-04 | 7 | 2015-04-12 | 2015-10-04 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 0.78 |
| 3808 | 1844791 | https://www.airbnb.com/rooms/1844791 | 20160104002432 | 2016-01-04 | Beautiful Craftsman - Fremont 3 Bed | Our charming home in fabulous Upper Fremont is... | This is a classically beautiful Craftsman home... | Our charming home in fabulous Upper Fremont is... | none | Fremont is wonderful; you will love it here. T... | Normal check-in time is 3-4:00; whenever possi... | The #5 bus is 2 blocks away and it is a 15-20 ... | https://a0.muscache.com/ac/pictures/26113769/f... | https://a0.muscache.com/im/pictures/26113769/f... | https://a0.muscache.com/ac/pictures/26113769/f... | https://a0.muscache.com/ac/pictures/26113769/f... | 7964921 | https://www.airbnb.com/users/show/7964921 | Charlie & Sarah | 2013-08-05 | Seattle, Washington, United States | Thank you for considering our house for your a... | within a few hours | 100% | 100% | f | https://a1.muscache.com/ac/users/7964921/profi... | https://a1.muscache.com/ac/users/7964921/profi... | Fremont | 2.0 | 2.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | Dayton Avenue North, Seattle, WA 98103, United... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.662036 | -122.350485 | t | House | Entire home/apt | 6 | 2.0 | 3.0 | 3.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $175.00 | NaN | NaN | $500.00 | $95.00 | 4 | $30.00 | 3 | 1125 | today | t | 19 | 19 | 19 | 294 | 2016-01-04 | 29 | 2013-12-10 | 2015-10-04 | 96.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 9.0 | f | NaN | WASHINGTON | f | strict | f | f | 2 | 1.15 |
| 3809 | 6120046 | https://www.airbnb.com/rooms/6120046 | 20160104002432 | 2016-01-04 | Lake Veiw Cottage in Fremont | From the deck of this quaint little apartment ... | This one bedroom apartment (Hippy Shack) is de... | From the deck of this quaint little apartment ... | none | This cottage apartment is located just a few b... | 1. Is the property quite private? ie. can we s... | This cottage apartment is located just a few b... | https://a2.muscache.com/ac/pictures/76273783/b... | https://a2.muscache.com/im/pictures/76273783/b... | https://a2.muscache.com/ac/pictures/76273783/b... | https://a2.muscache.com/ac/pictures/76273783/b... | 31752892 | https://www.airbnb.com/users/show/31752892 | Megan | 2015-04-22 | Seattle, Washington, United States | NaN | within a day | 100% | 100% | f | https://a2.muscache.com/ac/users/31752892/prof... | https://a2.muscache.com/ac/users/31752892/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | Albion Place North, Seattle, WA 98103, United ... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.648689 | -122.343915 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 1.0 | Real Bed | {"Wheelchair Accessible",Kitchen,Heating,"Fami... | NaN | $120.00 | $600.00 | $2,200.00 | NaN | $75.00 | 2 | $0.00 | 4 | 30 | 5 months ago | t | 30 | 60 | 90 | 365 | 2016-01-04 | 10 | 2015-04-26 | 2015-08-30 | 80.0 | 8.0 | 7.0 | 9.0 | 9.0 | 9.0 | 8.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 1.18 |
| 3810 | 262764 | https://www.airbnb.com/rooms/262764 | 20160104002432 | 2016-01-04 | Fremont Farmhouse | Our 2BR/1 bath home in Fremont's most fun neig... | 1200 ft2 2BR, 1 Bath farmhouse with a large, t... | Our 2BR/1 bath home in Fremont's most fun neig... | none | We love that Fremont is so centrally located t... | We have two cats, Polly and Theo. They are ind... | We're centrally located to several bus stops t... | https://a1.muscache.com/ac/pictures/75088108/6... | https://a1.muscache.com/im/pictures/75088108/6... | https://a1.muscache.com/ac/pictures/75088108/6... | https://a1.muscache.com/ac/pictures/75088108/6... | 1379138 | https://www.airbnb.com/users/show/1379138 | Rachel | 2011-11-07 | Seattle, Washington, United States | We are a professional family with 2 high energ... | within an hour | 100% | 100% | f | https://a0.muscache.com/ac/users/1379138/profi... | https://a0.muscache.com/ac/users/1379138/profi... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'linkedin', 'reviews', 'kba'] | t | t | N Bowdoin Pl, Seattle, WA 98103, United States | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.654205 | -122.352604 | t | House | Entire home/apt | 5 | 1.0 | 2.0 | 3.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | 1200.0 | $154.00 | $1,120.00 | $5,500.00 | $150.00 | $85.00 | 4 | $50.00 | 2 | 14 | 4 days ago | t | 13 | 43 | 73 | 227 | 2016-01-04 | 5 | 2015-10-01 | 2015-12-27 | 92.0 | 9.0 | 8.0 | 10.0 | 10.0 | 10.0 | 8.0 | f | NaN | WASHINGTON | f | strict | f | f | 1 | 1.56 |
| 3811 | 8578490 | https://www.airbnb.com/rooms/8578490 | 20160104002432 | 2016-01-04 | Super Convenient Top Floor Apt | In the true spirit of AirBNB this unit is avai... | The building is older (1970's) so not the mode... | In the true spirit of AirBNB this unit is avai... | none | I am equidistant to Fremont and Wallingford an... | Laundry is available but is $1.75 to wash and ... | How to Get to: UW/Husky Stadium): 10 minute d... | https://a2.muscache.com/ac/pictures/109014114/... | https://a2.muscache.com/im/pictures/109014114/... | https://a2.muscache.com/ac/pictures/109014114/... | https://a2.muscache.com/ac/pictures/109014114/... | 11847918 | https://www.airbnb.com/users/show/11847918 | Ryan | 2014-02-01 | Seattle, Washington, United States | NaN | within a few hours | 100% | 100% | f | https://a1.muscache.com/ac/users/11847918/prof... | https://a1.muscache.com/ac/users/11847918/prof... | Fremont | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | Whitman Avenue North, Seattle, WA 98103, Unite... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98103 | Seattle | Seattle, WA | US | United States | 47.657898 | -122.346692 | t | Apartment | Entire home/apt | 3 | 1.0 | 1.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $65.00 | NaN | NaN | NaN | $20.00 | 1 | $0.00 | 1 | 1125 | a week ago | t | 2 | 10 | 13 | 221 | 2016-01-04 | 2 | 2015-10-01 | 2015-10-16 | 100.0 | 9.0 | 8.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 0.63 |
| 3812 | 3383329 | https://www.airbnb.com/rooms/3383329 | 20160104002432 | 2016-01-04 | OF THE TREE & CLOUDS. KID FRIENDLY! | Of the Tree & Clouds' "Roots" apartment is 8 b... | The 1-bedroom, ground-floor Roots apartment is... | Of the Tree & Clouds' "Roots" apartment is 8 b... | none | It's taken me a while to figure out why Fremon... | There is NO television. We do have good WI-FI.... | The apartment is easily accessed from I-5 Nort... | https://a0.muscache.com/ac/pictures/108686685/... | https://a0.muscache.com/im/pictures/108686685/... | https://a0.muscache.com/ac/pictures/108686685/... | https://a0.muscache.com/ac/pictures/108686685/... | 3443346 | https://www.airbnb.com/users/show/3443346 | Jacqueline | 2012-09-01 | Seattle, Washington, United States | I’ve been a landlord (and loved it) for fourte... | within an hour | 100% | 100% | t | https://a0.muscache.com/ac/users/3443346/profi... | https://a0.muscache.com/ac/users/3443346/profi... | Fremont | 3.0 | 3.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | Northwest 39th Street, Seattle, WA 98107, Unit... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.654516 | -122.358124 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 2.0 | Real Bed | {Internet,"Wireless Internet",Kitchen,"Free Pa... | NaN | $95.00 | $600.00 | $2,200.00 | $500.00 | NaN | 2 | $8.00 | 3 | 365 | yesterday | t | 11 | 30 | 43 | 287 | 2016-01-04 | 73 | 2014-07-08 | 2015-12-29 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | f | NaN | WASHINGTON | t | moderate | t | t | 3 | 4.01 |
| 3813 | 8101950 | https://www.airbnb.com/rooms/8101950 | 20160104002432 | 2016-01-04 | 3BR Mountain View House in Seattle | Our 3BR/2BA house boasts incredible views of t... | Our 3BR/2BA house bright, stylish, and wheelch... | Our 3BR/2BA house boasts incredible views of t... | none | We're located near lots of family fun. Woodlan... | NaN | NaN | https://a2.muscache.com/ac/pictures/103217071/... | https://a2.muscache.com/im/pictures/103217071/... | https://a2.muscache.com/ac/pictures/103217071/... | https://a2.muscache.com/ac/pictures/103217071/... | 31148752 | https://www.airbnb.com/users/show/31148752 | Bo | 2015-04-13 | US | NaN | within a few hours | 99% | 100% | f | https://a2.muscache.com/ac/users/31148752/prof... | https://a2.muscache.com/ac/users/31148752/prof... | Holly | 354.0 | 354.0 | ['email', 'phone', 'linkedin', 'reviews', 'jum... | t | t | Northwest 48th Street, Seattle, WA 98107, Unit... | Fremont | Fremont | Other neighborhoods | Seattle | WA | 98107 | Seattle | Seattle, WA | US | United States | 47.664295 | -122.359170 | t | House | Entire home/apt | 6 | 2.0 | 3.0 | 3.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet","A... | NaN | $359.00 | NaN | NaN | NaN | $230.00 | 1 | $0.00 | 3 | 1125 | today | t | 18 | 32 | 32 | 32 | 2016-01-04 | 1 | 2015-09-27 | 2015-09-27 | 80.0 | 8.0 | 10.0 | 4.0 | 8.0 | 10.0 | 8.0 | f | NaN | WASHINGTON | f | strict | f | f | 8 | 0.30 |
| 3814 | 8902327 | https://www.airbnb.com/rooms/8902327 | 20160104002432 | 2016-01-04 | Portage Bay View!-One Bedroom Apt | 800 square foot 1 bedroom basement apartment w... | This space has a great view of Portage Bay wit... | 800 square foot 1 bedroom basement apartment w... | none | The neighborhood is a quiet oasis that is clos... | This is a basement apartment in a newer reside... | Uber and Car2go are good options in Seattle. T... | https://a2.muscache.com/ac/pictures/626d4b1f-6... | https://a2.muscache.com/im/pictures/626d4b1f-6... | https://a2.muscache.com/ac/pictures/626d4b1f-6... | https://a2.muscache.com/ac/pictures/626d4b1f-6... | 46566046 | https://www.airbnb.com/users/show/46566046 | Glen | 2015-10-14 | Seattle, Washington, United States | I am a 58 year old male that is married to Mag... | within an hour | 100% | 100% | f | https://a2.muscache.com/ac/pictures/d7e59b0d-8... | https://a2.muscache.com/ac/pictures/d7e59b0d-8... | Portage Bay | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'jum... | t | t | Fuhrman Avenue East, Seattle, WA 98102, United... | Portage Bay | Portage Bay | Capitol Hill | Seattle | WA | 98102 | Seattle | Seattle, WA | US | United States | 47.649552 | -122.318309 | t | Apartment | Entire home/apt | 4 | 1.0 | 1.0 | 2.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $79.00 | NaN | NaN | $500.00 | $50.00 | 3 | $25.00 | 2 | 29 | 2 days ago | t | 6 | 26 | 44 | 273 | 2016-01-04 | 2 | 2015-12-18 | 2015-12-24 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | f | NaN | WASHINGTON | f | moderate | f | f | 1 | 2.00 |
| 3815 | 10267360 | https://www.airbnb.com/rooms/10267360 | 20160104002432 | 2016-01-04 | Private apartment view of Lake WA | Very comfortable lower unit. Quiet, charming m... | NaN | Very comfortable lower unit. Quiet, charming m... | none | NaN | NaN | NaN | https://a2.muscache.com/ac/pictures/a5974f04-2... | https://a2.muscache.com/im/pictures/a5974f04-2... | https://a2.muscache.com/ac/pictures/a5974f04-2... | https://a2.muscache.com/ac/pictures/a5974f04-2... | 52791370 | https://www.airbnb.com/users/show/52791370 | Virginia | 2015-12-30 | US | NaN | NaN | NaN | NaN | f | https://a2.muscache.com/ac/pictures/efc75826-1... | https://a2.muscache.com/ac/pictures/efc75826-1... | NaN | 1.0 | 1.0 | ['phone'] | t | f | South Laurel Street, Seattle, WA 98178, United... | NaN | Rainier Beach | Rainier Valley | Seattle | WA | 98178 | Seattle | Seattle, WA | US | United States | 47.508453 | -122.240607 | f | House | Entire home/apt | 2 | 1.0 | 1.0 | 1.0 | Real Bed | {"Cable TV","Wireless Internet",Kitchen,"Free ... | NaN | $93.00 | $450.00 | NaN | $250.00 | $35.00 | 2 | $20.00 | 1 | 7 | 4 days ago | t | 29 | 59 | 88 | 88 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | moderate | f | f | 1 | NaN |
| 3816 | 9604740 | https://www.airbnb.com/rooms/9604740 | 20160104002432 | 2016-01-04 | Amazing View with Modern Comfort! | Cozy studio condo in the heart on Madison Park... | Fully furnished unit to accommodate most needs... | Cozy studio condo in the heart on Madison Park... | none | Madison Park offers a peaceful slow pace upsca... | NaN | Yes | https://a2.muscache.com/ac/pictures/202e4ad6-b... | https://a2.muscache.com/im/pictures/202e4ad6-b... | https://a2.muscache.com/ac/pictures/202e4ad6-b... | https://a2.muscache.com/ac/pictures/202e4ad6-b... | 25522052 | https://www.airbnb.com/users/show/25522052 | Karen | 2015-01-03 | Tacoma, Washington, United States | NaN | within an hour | 100% | NaN | f | https://a0.muscache.com/ac/users/25522052/prof... | https://a0.muscache.com/ac/users/25522052/prof... | NaN | 1.0 | 1.0 | ['email', 'phone', 'facebook', 'reviews', 'kba'] | t | t | 43rd Avenue East, Seattle, WA 98112, United St... | NaN | Madison Park | Capitol Hill | Seattle | WA | 98112 | Seattle | Seattle, WA | US | United States | 47.632335 | -122.275530 | f | Condominium | Entire home/apt | 2 | 1.0 | 0.0 | 1.0 | Real Bed | {TV,"Wireless Internet",Kitchen,"Free Parking ... | NaN | $99.00 | NaN | NaN | $300.00 | $45.00 | 1 | $0.00 | 3 | 1125 | never | t | 30 | 60 | 90 | 179 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | moderate | f | f | 1 | NaN |
| 3817 | 10208623 | https://www.airbnb.com/rooms/10208623 | 20160104002432 | 2016-01-04 | Large Lakefront Apartment | All hardwood floors, fireplace, 65" TV with Xb... | NaN | All hardwood floors, fireplace, 65" TV with Xb... | none | NaN | Also our puppy will be boarded away. | NaN | https://a2.muscache.com/ac/pictures/596705b3-0... | https://a2.muscache.com/im/pictures/596705b3-0... | https://a2.muscache.com/ac/pictures/596705b3-0... | https://a2.muscache.com/ac/pictures/596705b3-0... | 14703116 | https://www.airbnb.com/users/show/14703116 | Gil | 2014-04-25 | Seattle, Washington, United States | NaN | within a day | 100% | NaN | f | https://a2.muscache.com/ac/pictures/8864f979-b... | https://a2.muscache.com/ac/pictures/8864f979-b... | Queen Anne | 1.0 | 1.0 | ['email', 'phone', 'reviews', 'kba'] | t | t | Westlake Avenue North, Seattle, WA 98109, Unit... | Queen Anne | East Queen Anne | Queen Anne | Seattle | WA | 98109 | Seattle | Seattle, WA | US | United States | 47.641186 | -122.342085 | t | Apartment | Entire home/apt | 3 | 1.5 | 2.0 | 1.0 | Real Bed | {TV,"Cable TV",Internet,"Wireless Internet",Ki... | NaN | $87.00 | NaN | NaN | NaN | NaN | 1 | $0.00 | 1 | 1125 | a week ago | t | 7 | 7 | 7 | 7 | 2016-01-04 | 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | f | NaN | WASHINGTON | f | flexible | f | f | 1 | NaN |
3818 rows × 92 columns
listings.describe()
| id | scrape_id | host_id | host_listings_count | host_total_listings_count | latitude | longitude | accommodates | bathrooms | bedrooms | beds | square_feet | guests_included | minimum_nights | maximum_nights | availability_30 | availability_60 | availability_90 | availability_365 | number_of_reviews | review_scores_rating | review_scores_accuracy | review_scores_cleanliness | review_scores_checkin | review_scores_communication | review_scores_location | review_scores_value | license | calculated_host_listings_count | reviews_per_month | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | 3.818000e+03 | 3.818000e+03 | 3.818000e+03 | 3816.000000 | 3816.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3802.000000 | 3812.000000 | 3817.000000 | 97.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3818.000000 | 3171.000000 | 3160.000000 | 3165.000000 | 3160.000000 | 3167.000000 | 3163.000000 | 3162.000000 | 0.0 | 3818.000000 | 3191.000000 |
| mean | 5.550111e+06 | 2.016010e+13 | 1.578556e+07 | 7.157757 | 7.157757 | 47.628961 | -122.333103 | 3.349398 | 1.259469 | 1.307712 | 1.735394 | 854.618557 | 1.672603 | 2.369303 | 780.447617 | 16.786276 | 36.814825 | 58.082504 | 244.772656 | 22.223415 | 94.539262 | 9.636392 | 9.556398 | 9.786709 | 9.809599 | 9.608916 | 9.452245 | NaN | 2.946307 | 2.078919 |
| std | 2.962660e+06 | 0.000000e+00 | 1.458382e+07 | 28.628149 | 28.628149 | 0.043052 | 0.031745 | 1.977599 | 0.590369 | 0.883395 | 1.139480 | 671.404893 | 1.311040 | 16.305902 | 1683.589007 | 12.173637 | 23.337541 | 34.063845 | 126.772526 | 37.730892 | 6.606083 | 0.698031 | 0.797274 | 0.595499 | 0.568211 | 0.629053 | 0.750259 | NaN | 5.893029 | 1.822348 |
| min | 3.335000e+03 | 2.016010e+13 | 4.193000e+03 | 1.000000 | 1.000000 | 47.505088 | -122.417219 | 1.000000 | 0.000000 | 0.000000 | 1.000000 | 0.000000 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 20.000000 | 2.000000 | 3.000000 | 2.000000 | 2.000000 | 4.000000 | 2.000000 | NaN | 1.000000 | 0.020000 |
| 25% | 3.258256e+06 | 2.016010e+13 | 3.275204e+06 | 1.000000 | 1.000000 | 47.609418 | -122.354320 | 2.000000 | 1.000000 | 1.000000 | 1.000000 | 420.000000 | 1.000000 | 1.000000 | 60.000000 | 2.000000 | 13.000000 | 28.000000 | 124.000000 | 2.000000 | 93.000000 | 9.000000 | 9.000000 | 10.000000 | 10.000000 | 9.000000 | 9.000000 | NaN | 1.000000 | 0.695000 |
| 50% | 6.118244e+06 | 2.016010e+13 | 1.055814e+07 | 1.000000 | 1.000000 | 47.623601 | -122.328874 | 3.000000 | 1.000000 | 1.000000 | 1.000000 | 750.000000 | 1.000000 | 2.000000 | 1125.000000 | 20.000000 | 46.000000 | 73.000000 | 308.000000 | 9.000000 | 96.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | NaN | 1.000000 | 1.540000 |
| 75% | 8.035127e+06 | 2.016010e+13 | 2.590309e+07 | 3.000000 | 3.000000 | 47.662694 | -122.310800 | 4.000000 | 1.000000 | 2.000000 | 2.000000 | 1200.000000 | 2.000000 | 2.000000 | 1125.000000 | 30.000000 | 59.000000 | 89.000000 | 360.000000 | 26.000000 | 99.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | NaN | 2.000000 | 3.000000 |
| max | 1.034016e+07 | 2.016010e+13 | 5.320861e+07 | 502.000000 | 502.000000 | 47.733358 | -122.240607 | 16.000000 | 8.000000 | 7.000000 | 15.000000 | 3000.000000 | 15.000000 | 1000.000000 | 100000.000000 | 30.000000 | 60.000000 | 90.000000 | 365.000000 | 474.000000 | 100.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | NaN | 37.000000 | 12.150000 |
reviews
| listing_id | id | date | reviewer_id | reviewer_name | comments | |
|---|---|---|---|---|---|---|
| 0 | 7202016 | 38917982 | 2015-07-19 | 28943674 | Bianca | Cute and cozy place. Perfect location to every... |
| 1 | 7202016 | 39087409 | 2015-07-20 | 32440555 | Frank | Kelly has a great room in a very central locat... |
| 2 | 7202016 | 39820030 | 2015-07-26 | 37722850 | Ian | Very spacious apartment, and in a great neighb... |
| 3 | 7202016 | 40813543 | 2015-08-02 | 33671805 | George | Close to Seattle Center and all it has to offe... |
| 4 | 7202016 | 41986501 | 2015-08-10 | 34959538 | Ming | Kelly was a great host and very accommodating ... |
| 5 | 7202016 | 43979139 | 2015-08-23 | 1154501 | Barent | Kelly was great, place was great, just what I ... |
| 6 | 7202016 | 45265631 | 2015-09-01 | 37853266 | Kevin | Kelly was great! Very nice and the neighborhoo... |
| 7 | 7202016 | 46749120 | 2015-09-13 | 24445447 | Rick | hola all bnb erz - Just left Seattle where I h... |
| 8 | 7202016 | 47783346 | 2015-09-21 | 249583 | Todd | Kelly's place is conveniently located on a qui... |
| 9 | 7202016 | 48388999 | 2015-09-26 | 38110731 | Tatiana | The place was really nice, clean, and the most... |
| 10 | 7202016 | 49441269 | 2015-10-04 | 39852826 | Tim | The place was really nice, clean and quiet at ... |
| 11 | 7202016 | 50490194 | 2015-10-12 | 384855 | Tony | The listing was exactly as described! Kelly's... |
| 12 | 7202016 | 53862449 | 2015-11-13 | 21607838 | Jason | Very welcoming and a nicer place to live in th... |
| 13 | 7202016 | 54562283 | 2015-11-21 | 17052263 | Don | Great location, great price, great host! Thank... |
| 14 | 7202016 | 55212826 | 2015-11-29 | 4774006 | Vivian | Staying at Kelly's was easy. The location was ... |
| 15 | 7202016 | 58268184 | 2016-01-02 | 41297839 | Travis | Kelly was an amazing host who made the stay ve... |
| 16 | 3946674 | 20798623 | 2014-10-05 | 9313038 | Angeline | Despite our late booking request, Rachel & Jon... |
| 17 | 3946674 | 21224862 | 2014-10-13 | 8385649 | Celine | Rachel & Jon have a nice house closed to downt... |
| 18 | 3946674 | 22877803 | 2014-11-16 | 9403201 | Rémy | Rachel and Jon have been the perfect hosts for... |
| 19 | 3946674 | 22938377 | 2014-11-17 | 2920596 | Jason | This house was a delightful bright place to st... |
| 20 | 3946674 | 23416253 | 2014-11-30 | 23579299 | Margit | Beautiful place, nice neighborhood and lovely ... |
| 21 | 3946674 | 23463915 | 2014-12-01 | 20706964 | Ashley | Super cozy home. Located near some good restau... |
| 22 | 3946674 | 23709531 | 2014-12-08 | 23941301 | Tim | Cute house, and Rachel and Jon were super nice... |
| 23 | 3946674 | 23961948 | 2014-12-15 | 7008965 | Gabriel | Rachel and Jon were really great hosts. Warm, ... |
| 24 | 3946674 | 24118813 | 2014-12-20 | 24025530 | Davi | The house was easy to locate and the arrangeme... |
| 25 | 3946674 | 24302648 | 2014-12-25 | 23834617 | Tim | Rachel and Jon were very obliging hosts, super... |
| 26 | 3946674 | 25275185 | 2015-01-11 | 11109842 | Michelle | What a great stay at Rachel and Jon's! They we... |
| 27 | 3946674 | 26338015 | 2015-02-09 | 9997395 | Jack | We had an amazing time and felt very welcome i... |
| 28 | 3946674 | 27110794 | 2015-02-25 | 4920230 | Adrienne | It was very easy to get in touch with Rachel t... |
| 29 | 3946674 | 27182900 | 2015-02-27 | 3002880 | Sasha | Rachel and Jon's home is beautiful and inspiri... |
| ... | ... | ... | ... | ... | ... | ... |
| 84819 | 3424991 | 44496259 | 2015-08-26 | 42076842 | Xu | I had a good experience staying with Michael a... |
| 84820 | 3424991 | 46558529 | 2015-09-11 | 1339330 | Timothy | This was a great place to stay. First off it ... |
| 84821 | 3424991 | 47823159 | 2015-09-21 | 7583246 | Jonah | Awesome location and price. The apartment was ... |
| 84822 | 3424991 | 48593190 | 2015-09-27 | 30353275 | Emiliano | Nice neighbourhood and warm welcome. |
| 84823 | 3424991 | 49062311 | 2015-09-30 | 26501715 | Bronwyn | Great location. I was a little scared to enter... |
| 84824 | 3424991 | 52847610 | 2015-11-02 | 40018387 | Jameson & Michelle | My boyfriend and I had a great experience stay... |
| 84825 | 3424991 | 54116274 | 2015-11-16 | 21979218 | Liam | Had a great stay. Michael and Leah made it re... |
| 84826 | 3424991 | 54757263 | 2015-11-23 | 30703249 | Julia | We had a good stay at Michael. He and Leah pro... |
| 84827 | 3424991 | 55074633 | 2015-11-27 | 26327758 | Tangwei | In big city, it is very hard to find a clean r... |
| 84828 | 1179538 | 54492069 | 2015-11-20 | 49301240 | Francesca | I was searching for a place last minute for my... |
| 84829 | 1179538 | 55507128 | 2015-12-01 | 49230937 | Natalie | Very nice apartment, clean and quite. |
| 84830 | 3624990 | 20029700 | 2014-09-22 | 6074769 | Christie | The location is super convenient to the state ... |
| 84831 | 3624990 | 23031040 | 2014-11-21 | 19473144 | Megan | This apartment is in a great location - easy w... |
| 84832 | 3624990 | 27384730 | 2015-03-03 | 23852813 | Justine | Absolutely perfect stay! Doug & Rebecca were s... |
| 84833 | 3624990 | 28773963 | 2015-03-30 | 13891549 | Cyanide & Happniess | Excellent room, very attentive property manage... |
| 84834 | 3624990 | 29827002 | 2015-04-13 | 5703826 | Janice | Great, clean place in a perfect location for a... |
| 84835 | 3624990 | 31793991 | 2015-05-10 | 13052628 | Jordan | What an amazing place to stay in Seattle! A fe... |
| 84836 | 3624990 | 32446221 | 2015-05-18 | 24660858 | Colleen | We had an excellent stay at Seattle Suites! Th... |
| 84837 | 3624990 | 32954604 | 2015-05-24 | 22378313 | Ryan | The apartment was clean and accurate to the de... |
| 84838 | 3624990 | 35297846 | 2015-06-17 | 2457555 | Sharon | We were warmly greeted by Doug at the time agr... |
| 84839 | 3624990 | 36782055 | 2015-07-01 | 33029028 | Simon | The apartment was clean, tidy and as described... |
| 84840 | 3624990 | 42509459 | 2015-08-14 | 1329969 | Joke | We were with 7 people in rebecca's two 2-bed a... |
| 84841 | 3624990 | 46118182 | 2015-09-08 | 2005229 | Brandon | Great place in the middle of the city. Easy to... |
| 84842 | 3624990 | 49000780 | 2015-09-30 | 21815461 | Kellye | We loved how close it was to the Convention Ce... |
| 84843 | 3624990 | 49768901 | 2015-10-06 | 37578535 | Michael | Comfortability upon arrival and everything wit... |
| 84844 | 3624990 | 50436321 | 2015-10-12 | 37419458 | Ryan | The description and pictures of the apartment ... |
| 84845 | 3624990 | 51024875 | 2015-10-17 | 6933252 | Linda | We had an excellent stay. It was clean and com... |
| 84846 | 3624990 | 51511988 | 2015-10-20 | 19543701 | Jaime | Gran ubicación, cerca de todo lo atractivo del... |
| 84847 | 3624990 | 52814482 | 2015-11-02 | 24445024 | Jørgen | Very good apartement, clean and well sized. Si... |
| 84848 | 9727246 | 56429621 | 2015-12-13 | 30860360 | Stephanie | Breanne was a great host. Check in was easy, s... |
84849 rows × 6 columns
review_scores = ['id', 'review_scores_rating', 'review_scores_accuracy', 'review_scores_cleanliness', 'review_scores_checkin', 'review_scores_communication', 'review_scores_location', 'review_scores_value', 'number_of_reviews']
listings_reviews = listings[review_scores]
listings_reviews
| id | review_scores_rating | review_scores_accuracy | review_scores_cleanliness | review_scores_checkin | review_scores_communication | review_scores_location | review_scores_value | number_of_reviews | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 241032 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 207 |
| 1 | 953595 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 43 |
| 2 | 3308979 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 20 |
| 3 | 7421966 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 4 | 278830 | 92.0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 9.0 | 38 |
| 5 | 5956968 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 17 |
| 6 | 1909058 | 99.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 58 |
| 7 | 856550 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 173 |
| 8 | 4948745 | 97.0 | 10.0 | 9.0 | 10.0 | 9.0 | 10.0 | 10.0 | 8 |
| 9 | 2493658 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 32 |
| 10 | 175576 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 181 |
| 11 | 4454295 | 97.0 | 10.0 | 10.0 | 9.0 | 10.0 | 10.0 | 9.0 | 8 |
| 12 | 3883392 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 13 |
| 13 | 8889257 | 100.0 | 10.0 | 10.0 | 9.0 | 9.0 | 10.0 | 10.0 | 3 |
| 14 | 5680462 | 98.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 18 |
| 15 | 8988178 | 80.0 | 8.0 | 10.0 | 8.0 | 8.0 | 8.0 | 8.0 | 1 |
| 16 | 3245876 | 95.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 9.0 | 84 |
| 17 | 4933447 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 45 |
| 18 | 7735464 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 19 | 6291829 | 85.0 | 10.0 | 9.0 | 9.0 | 9.0 | 8.0 | 8.0 | 5 |
| 20 | 9218403 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 21 | 4125779 | 84.0 | 9.0 | 9.0 | 9.0 | 9.0 | 10.0 | 8.0 | 11 |
| 22 | 8942678 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 23 | 10106055 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 24 | 6362362 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 25 | 3544550 | 100.0 | 10.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 8 |
| 26 | 9025039 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 27 | 3200646 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 9.0 | 80 |
| 28 | 8859380 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 6 |
| 29 | 4520099 | 85.0 | 8.0 | 9.0 | 7.0 | 10.0 | 9.0 | 9.0 | 4 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 3788 | 7745196 | 99.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 14 |
| 3789 | 4645405 | 90.0 | 9.0 | 9.0 | 9.0 | 10.0 | 9.0 | 9.0 | 23 |
| 3790 | 2755730 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 75 |
| 3791 | 7949448 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 11 |
| 3792 | 9288840 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 3793 | 3312406 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 78 |
| 3794 | 6621924 | 90.0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 8.0 | 21 |
| 3795 | 5673552 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10 |
| 3796 | 609701 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 233 |
| 3797 | 10118341 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 3798 | 2614387 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 128 |
| 3799 | 7735100 | 95.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 5 |
| 3800 | 5482204 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 3801 | 4524575 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 28 |
| 3802 | 8562314 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 3803 | 9698202 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 4 |
| 3804 | 7178490 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 12 |
| 3805 | 8054902 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10 |
| 3806 | 5458027 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 3807 | 4940491 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 7 |
| 3808 | 1844791 | 96.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 9.0 | 29 |
| 3809 | 6120046 | 80.0 | 8.0 | 7.0 | 9.0 | 9.0 | 9.0 | 8.0 | 10 |
| 3810 | 262764 | 92.0 | 9.0 | 8.0 | 10.0 | 10.0 | 10.0 | 8.0 | 5 |
| 3811 | 8578490 | 100.0 | 9.0 | 8.0 | 10.0 | 10.0 | 10.0 | 10.0 | 2 |
| 3812 | 3383329 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 73 |
| 3813 | 8101950 | 80.0 | 8.0 | 10.0 | 4.0 | 8.0 | 10.0 | 8.0 | 1 |
| 3814 | 8902327 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 2 |
| 3815 | 10267360 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 3816 | 9604740 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
| 3817 | 10208623 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 0 |
3818 rows × 9 columns
listings_reviews.describe()
| id | review_scores_rating | review_scores_accuracy | review_scores_cleanliness | review_scores_checkin | review_scores_communication | review_scores_location | review_scores_value | number_of_reviews | |
|---|---|---|---|---|---|---|---|---|---|
| count | 3.818000e+03 | 3171.000000 | 3160.000000 | 3165.000000 | 3160.000000 | 3167.000000 | 3163.000000 | 3162.000000 | 3818.000000 |
| mean | 5.550111e+06 | 94.539262 | 9.636392 | 9.556398 | 9.786709 | 9.809599 | 9.608916 | 9.452245 | 22.223415 |
| std | 2.962660e+06 | 6.606083 | 0.698031 | 0.797274 | 0.595499 | 0.568211 | 0.629053 | 0.750259 | 37.730892 |
| min | 3.335000e+03 | 20.000000 | 2.000000 | 3.000000 | 2.000000 | 2.000000 | 4.000000 | 2.000000 | 0.000000 |
| 25% | 3.258256e+06 | 93.000000 | 9.000000 | 9.000000 | 10.000000 | 10.000000 | 9.000000 | 9.000000 | 2.000000 |
| 50% | 6.118244e+06 | 96.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 9.000000 |
| 75% | 8.035127e+06 | 99.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 26.000000 |
| max | 1.034016e+07 | 100.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 10.000000 | 474.000000 |
listings_reviews.dropna(inplace=True)
/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
listings_reviews
| id | review_scores_rating | review_scores_accuracy | review_scores_cleanliness | review_scores_checkin | review_scores_communication | review_scores_location | review_scores_value | number_of_reviews | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 241032 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 207 |
| 1 | 953595 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 43 |
| 2 | 3308979 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 20 |
| 4 | 278830 | 92.0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 9.0 | 38 |
| 5 | 5956968 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 17 |
| 6 | 1909058 | 99.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 58 |
| 7 | 856550 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 173 |
| 8 | 4948745 | 97.0 | 10.0 | 9.0 | 10.0 | 9.0 | 10.0 | 10.0 | 8 |
| 9 | 2493658 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 32 |
| 10 | 175576 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 181 |
| 11 | 4454295 | 97.0 | 10.0 | 10.0 | 9.0 | 10.0 | 10.0 | 9.0 | 8 |
| 12 | 3883392 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 13 |
| 13 | 8889257 | 100.0 | 10.0 | 10.0 | 9.0 | 9.0 | 10.0 | 10.0 | 3 |
| 14 | 5680462 | 98.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 18 |
| 15 | 8988178 | 80.0 | 8.0 | 10.0 | 8.0 | 8.0 | 8.0 | 8.0 | 1 |
| 16 | 3245876 | 95.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 9.0 | 84 |
| 17 | 4933447 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 45 |
| 19 | 6291829 | 85.0 | 10.0 | 9.0 | 9.0 | 9.0 | 8.0 | 8.0 | 5 |
| 20 | 9218403 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 21 | 4125779 | 84.0 | 9.0 | 9.0 | 9.0 | 9.0 | 10.0 | 8.0 | 11 |
| 22 | 8942678 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 24 | 6362362 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 25 | 3544550 | 100.0 | 10.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 8 |
| 27 | 3200646 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 9.0 | 80 |
| 28 | 8859380 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 6 |
| 29 | 4520099 | 85.0 | 8.0 | 9.0 | 7.0 | 10.0 | 9.0 | 9.0 | 4 |
| 30 | 2481869 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 38 |
| 31 | 1110749 | 92.0 | 9.0 | 9.0 | 10.0 | 9.0 | 10.0 | 9.0 | 68 |
| 32 | 5978498 | 88.0 | 9.0 | 9.0 | 9.0 | 9.0 | 10.0 | 9.0 | 8 |
| 33 | 5021081 | 75.0 | 8.0 | 9.0 | 8.0 | 9.0 | 9.0 | 8.0 | 5 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 3782 | 4100009 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 41 |
| 3783 | 4738971 | 88.0 | 9.0 | 9.0 | 10.0 | 9.0 | 10.0 | 9.0 | 22 |
| 3784 | 692671 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 50 |
| 3785 | 5893969 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 5 |
| 3786 | 215954 | 98.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 19 |
| 3787 | 2494157 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 8 |
| 3788 | 7745196 | 99.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 14 |
| 3789 | 4645405 | 90.0 | 9.0 | 9.0 | 9.0 | 10.0 | 9.0 | 9.0 | 23 |
| 3790 | 2755730 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 75 |
| 3791 | 7949448 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 11 |
| 3793 | 3312406 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 78 |
| 3794 | 6621924 | 90.0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 8.0 | 21 |
| 3795 | 5673552 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10 |
| 3796 | 609701 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 233 |
| 3797 | 10118341 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 3798 | 2614387 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 128 |
| 3799 | 7735100 | 95.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 5 |
| 3801 | 4524575 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 28 |
| 3803 | 9698202 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 4 |
| 3804 | 7178490 | 95.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 12 |
| 3805 | 8054902 | 98.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10 |
| 3806 | 5458027 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 1 |
| 3807 | 4940491 | 97.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 7 |
| 3808 | 1844791 | 96.0 | 10.0 | 9.0 | 10.0 | 10.0 | 10.0 | 9.0 | 29 |
| 3809 | 6120046 | 80.0 | 8.0 | 7.0 | 9.0 | 9.0 | 9.0 | 8.0 | 10 |
| 3810 | 262764 | 92.0 | 9.0 | 8.0 | 10.0 | 10.0 | 10.0 | 8.0 | 5 |
| 3811 | 8578490 | 100.0 | 9.0 | 8.0 | 10.0 | 10.0 | 10.0 | 10.0 | 2 |
| 3812 | 3383329 | 96.0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 10.0 | 73 |
| 3813 | 8101950 | 80.0 | 8.0 | 10.0 | 4.0 | 8.0 | 10.0 | 8.0 | 1 |
| 3814 | 8902327 | 100.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 2 |
3158 rows × 9 columns
review_scores[1:]
['review_scores_rating', 'review_scores_accuracy', 'review_scores_cleanliness', 'review_scores_checkin', 'review_scores_communication', 'review_scores_location', 'review_scores_value', 'number_of_reviews']
First, we want to make sure the customer is having good time while staying with AirBNB Host:
fig = go.Figure()
for i in review_scores[2:-1]:
fig.add_trace(go.Histogram(x=listings_reviews[i],name=i))
# Overlay both histograms
fig.update_layout(title = 'Review Scores For Each Category', barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()
As we can see from the graph above most of the reviews are excellent, which means the customers are happy.
Here I will clean some features in the listings data set, for further investigations.
I will start by writing a function for host features cleaning.
def clean_host_feature(listings):
'''
Description: This function is used to clean and select the features
related to host data in the listings data set.
Arguments:
AirBNB listings dataframe.
Returns:
Cleaned dataframe with only host related features.
'''
host_features = ['host_response_rate', 'host_acceptance_rate', 'host_is_superhost', 'host_thumbnail_url', 'host_picture_url', 'host_neighbourhood', 'host_listings_count', 'host_total_listings_count', 'host_verifications', 'host_has_profile_pic', 'host_identity_verified']
listings_host_features = listings[host_features]
listings_host_features['host_thumbnail_url'] = listings_host_features.apply(lambda x: 0 if pd.isna(x['host_thumbnail_url']) else 1, axis=1)
listings_host_features['host_picture_url'] = listings_host_features.apply(lambda x: 0 if pd.isna(x['host_picture_url']) else 1, axis=1)
listings_host_features['host_has_profile_pic'] = listings_host_features.apply(lambda x: 1 if x['host_has_profile_pic']=='t' else 0, axis=1)
listings_host_features['host_identity_verified'] = listings_host_features.apply(lambda x: 1 if x['host_identity_verified']=='t' else 0, axis=1)
listings_host_features['host_verifications'] = listings_host_features.apply(lambda x: ast.literal_eval(x['host_verifications']), axis=1)
return listings_host_features
listings_host_features = clean_host_feature(listings)
/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:15: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy /home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:16: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy /home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:17: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy /home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:18: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy /home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:19: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
listings_host_features
| host_response_rate | host_acceptance_rate | host_is_superhost | host_thumbnail_url | host_picture_url | host_neighbourhood | host_listings_count | host_total_listings_count | host_verifications | host_has_profile_pic | host_identity_verified | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 96% | 100% | f | 1 | 1 | Queen Anne | 3.0 | 3.0 | [email, phone, reviews, kba] | 1 | 1 |
| 1 | 98% | 100% | t | 1 | 1 | Queen Anne | 6.0 | 6.0 | [email, phone, facebook, linkedin, reviews, ju... | 1 | 1 |
| 2 | 67% | 100% | f | 1 | 1 | Queen Anne | 2.0 | 2.0 | [email, phone, google, reviews, jumio] | 1 | 1 |
| 3 | NaN | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, jumio] | 1 | 1 |
| 4 | 100% | NaN | f | 1 | 1 | Queen Anne | 2.0 | 2.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 5 | NaN | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 6 | 100% | 100% | t | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 7 | 100% | 100% | t | 1 | 1 | Queen Anne | 5.0 | 5.0 | [email, phone, facebook, google, linkedin, rev... | 1 | 1 |
| 8 | NaN | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, linkedin, reviews, kba] | 1 | 1 |
| 9 | 98% | 100% | t | 1 | 1 | Queen Anne | 6.0 | 6.0 | [email, phone, facebook, linkedin, reviews, ju... | 1 | 1 |
| 10 | 100% | 100% | t | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 11 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 12 | 100% | 100% | t | 1 | 1 | NaN | 1.0 | 1.0 | [email, phone, linkedin, reviews, jumio] | 1 | 1 |
| 13 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 14 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 15 | 100% | 100% | f | 1 | 1 | NaN | 1.0 | 1.0 | [email, reviews, kba] | 1 | 0 |
| 16 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, linkedin, reviews, ju... | 1 | 1 |
| 17 | 100% | 100% | t | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 18 | NaN | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, jumio] | 1 | 1 |
| 19 | NaN | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, linkedin, reviews, kba] | 1 | 1 |
| 20 | 100% | 100% | f | 1 | 1 | NaN | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 21 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews] | 1 | 0 |
| 22 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [phone, reviews] | 1 | 0 |
| 23 | NaN | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [phone] | 1 | 0 |
| 24 | NaN | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, reviews] | 1 | 0 |
| 25 | 67% | 100% | f | 1 | 1 | Queen Anne | 2.0 | 2.0 | [email, phone, google, reviews, jumio] | 1 | 1 |
| 26 | 100% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, jumio] | 1 | 1 |
| 27 | 100% | 100% | t | 1 | 1 | Queen Anne | 5.0 | 5.0 | [email, phone, facebook, google, linkedin, rev... | 1 | 1 |
| 28 | 100% | 100% | f | 1 | 1 | Queen Anne | 5.0 | 5.0 | [email, phone, reviews, jumio, kba] | 1 | 1 |
| 29 | 71% | 100% | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 3788 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, google, reviews, kba] | 1 | 1 |
| 3789 | 100% | 100% | f | 1 | 1 | Fremont | 2.0 | 2.0 | [email, phone, reviews, kba] | 1 | 1 |
| 3790 | 100% | 100% | t | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 3791 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, linkedin, reviews, kba] | 1 | 1 |
| 3792 | 100% | NaN | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, kba] | 1 | 0 |
| 3793 | 100% | 100% | t | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 3794 | 80% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, reviews, jumio] | 1 | 1 |
| 3795 | 100% | 100% | t | 1 | 1 | NaN | 1.0 | 1.0 | [email, phone, facebook, reviews, jumio] | 1 | 1 |
| 3796 | 100% | 100% | t | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, reviews, jumio] | 1 | 1 |
| 3797 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, linkedin, reviews, kba] | 1 | 1 |
| 3798 | 100% | 100% | f | 1 | 1 | Fremont | 2.0 | 2.0 | [email, phone, reviews, kba] | 1 | 1 |
| 3799 | 25% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 3800 | NaN | NaN | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone] | 1 | 0 |
| 3801 | 100% | 100% | t | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, linkedin, reviews, kba] | 1 | 1 |
| 3802 | NaN | NaN | f | 1 | 1 | NaN | 1.0 | 1.0 | [email, phone] | 1 | 0 |
| 3803 | 97% | 100% | f | 1 | 1 | Queen Anne | 9.0 | 9.0 | [email, phone, facebook, linkedin, reviews, ju... | 1 | 1 |
| 3804 | 100% | 100% | t | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 3805 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, facebook, linkedin, reviews, ju... | 1 | 1 |
| 3806 | 100% | 100% | t | 1 | 1 | Fremont | 2.0 | 2.0 | [email, phone, reviews, jumio] | 1 | 1 |
| 3807 | 100% | 100% | f | 1 | 1 | Wallingford | 1.0 | 1.0 | [email, phone, reviews] | 1 | 0 |
| 3808 | 100% | 100% | f | 1 | 1 | Fremont | 2.0 | 2.0 | [email, phone, reviews, kba] | 1 | 1 |
| 3809 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 3810 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, linkedin, reviews, kba] | 1 | 1 |
| 3811 | 100% | 100% | f | 1 | 1 | Fremont | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
| 3812 | 100% | 100% | t | 1 | 1 | Fremont | 3.0 | 3.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 3813 | 99% | 100% | f | 1 | 1 | Holly | 354.0 | 354.0 | [email, phone, linkedin, reviews, jumio] | 1 | 1 |
| 3814 | 100% | 100% | f | 1 | 1 | Portage Bay | 1.0 | 1.0 | [email, phone, facebook, reviews, jumio] | 1 | 1 |
| 3815 | NaN | NaN | f | 1 | 1 | NaN | 1.0 | 1.0 | [phone] | 1 | 0 |
| 3816 | 100% | NaN | f | 1 | 1 | NaN | 1.0 | 1.0 | [email, phone, facebook, reviews, kba] | 1 | 1 |
| 3817 | 100% | NaN | f | 1 | 1 | Queen Anne | 1.0 | 1.0 | [email, phone, reviews, kba] | 1 | 1 |
3818 rows × 11 columns
Now I will prepare the locations data set:
locations = ['id','latitude', 'longitude', 'neighbourhood', 'street','is_location_exact']
listings_locations = listings[locations]
listings_locations = listings_locations[listings_locations['is_location_exact']=='t'].drop('is_location_exact',axis=1)
listings_locations['listing_id']=listings_locations['id']
listings_locations=listings_locations.drop('id',axis=1)
listings_locations
| latitude | longitude | neighbourhood | street | listing_id | |
|---|---|---|---|---|---|
| 0 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 |
| 1 | 47.639123 | -122.365666 | Queen Anne | 7th Avenue West, Seattle, WA 98119, United States | 953595 |
| 2 | 47.629724 | -122.369483 | Queen Anne | West Lee Street, Seattle, WA 98119, United States | 3308979 |
| 3 | 47.638473 | -122.369279 | Queen Anne | 8th Avenue West, Seattle, WA 98119, United States | 7421966 |
| 4 | 47.632918 | -122.372471 | Queen Anne | 14th Ave W, Seattle, WA 98119, United States | 278830 |
| 5 | 47.630525 | -122.366174 | Queen Anne | West Comstock Street, Seattle, WA 98119, Unite... | 5956968 |
| 6 | 47.636605 | -122.368519 | Queen Anne | 10th Avenue West, Seattle, WA 98119, United St... | 1909058 |
| 7 | 47.640161 | -122.375856 | Queen Anne | West Wheeler Street, Seattle, WA 98119, United... | 856550 |
| 8 | 47.632410 | -122.357216 | Queen Anne | Queen Anne Avenue North, Seattle, WA 98109, Un... | 4948745 |
| 9 | 47.637492 | -122.366889 | Queen Anne | 7th Avenue West, Seattle, WA 98119, United States | 2493658 |
| 10 | 47.635482 | -122.358478 | Queen Anne | 1st Ave W, Seattle, WA 98119, United States | 175576 |
| 11 | 47.637214 | -122.360046 | Queen Anne | 3rd Avenue West, Seattle, WA 98119, United States | 4454295 |
| 12 | 47.635546 | -122.373171 | NaN | West Howe Street, Seattle, WA 98119, United St... | 3883392 |
| 13 | 47.629507 | -122.367629 | Queen Anne | West Prospect Street, Seattle, WA 98119, Unite... | 8889257 |
| 14 | 47.639203 | -122.365863 | Queen Anne | 7th Avenue West, Seattle, WA 98119, United States | 5680462 |
| 16 | 47.626200 | -122.366602 | Queen Anne | West Mercer Place, Seattle, WA 98119, United S... | 3245876 |
| 17 | 47.640646 | -122.372406 | Queen Anne | 12th Avenue West, Seattle, WA 98119, United St... | 4933447 |
| 18 | 47.639776 | -122.372235 | Queen Anne | 11th Avenue West, Seattle, WA 98119, United St... | 7735464 |
| 19 | 47.636025 | -122.358694 | Queen Anne | 1st Avenue West, Seattle, WA 98119, United States | 6291829 |
| 21 | 47.636374 | -122.361033 | Queen Anne | 2nd Avenue West, Seattle, WA 98119, United States | 4125779 |
| 22 | 47.635632 | -122.358881 | Queen Anne | 1st Avenue West, Seattle, WA 98119, United States | 8942678 |
| 23 | 47.633394 | -122.371920 | Queen Anne | West Galer Street, Seattle, WA 98119, United S... | 10106055 |
| 24 | 47.638517 | -122.369581 | Queen Anne | 10th Avenue West, Seattle, WA 98119, United St... | 6362362 |
| 25 | 47.631397 | -122.367767 | Queen Anne | 7th Avenue West, Seattle, WA 98119, United States | 3544550 |
| 26 | 47.638752 | -122.367973 | Queen Anne | West McGraw Street, Seattle, WA 98119, United ... | 9025039 |
| 27 | 47.639266 | -122.374726 | Queen Anne | West Wheeler Street, Seattle, WA 98119, United... | 3200646 |
| 28 | 47.629907 | -122.368948 | Queen Anne | 9th Avenue West, Seattle, WA 98119, United States | 8859380 |
| 29 | 47.639816 | -122.374338 | Queen Anne | 14th Avenue West, Seattle, WA 98119, United St... | 4520099 |
| 30 | 47.639008 | -122.365320 | Queen Anne | 7th Avenue West, Seattle, WA 98119, United States | 2481869 |
| 31 | 47.635085 | -122.364443 | Queen Anne | 5th Avenue West, Seattle, WA 98119, United States | 1110749 |
| ... | ... | ... | ... | ... | ... |
| 3784 | 47.660342 | -122.364747 | Fremont | NW 50th St, Seattle, WA 98107, United States | 692671 |
| 3785 | 47.653176 | -122.346211 | Fremont | Bridge Way North, Seattle, WA 98103, United St... | 5893969 |
| 3786 | 47.661396 | -122.352256 | Fremont | Dayton Ave N, Seattle, WA 98103, United States | 215954 |
| 3787 | 47.658552 | -122.348265 | Fremont | Linden Avenue North, Seattle, WA 98103, United... | 2494157 |
| 3788 | 47.656739 | -122.344865 | Fremont | Woodland Park Avenue North, Seattle, WA 98103,... | 7745196 |
| 3789 | 47.661171 | -122.349923 | Fremont | North 46th Street, Seattle, WA 98103, United S... | 4645405 |
| 3790 | 47.649271 | -122.347817 | Fremont | North 35th Street, Seattle, WA 98103, United S... | 2755730 |
| 3791 | 47.659149 | -122.363466 | Fremont | 6th Avenue Northwest, Seattle, WA 98107, Unite... | 7949448 |
| 3792 | 47.663040 | -122.348499 | Fremont | North 46th Street, Seattle, WA 98103, United S... | 9288840 |
| 3793 | 47.660056 | -122.357683 | Fremont | Baker Avenue Northwest, Seattle, WA 98107, Uni... | 3312406 |
| 3794 | 47.654199 | -122.359987 | Fremont | Northwest Bowdoin Place, Seattle, WA 98107, Un... | 6621924 |
| 3796 | 47.656508 | -122.360571 | Fremont | NW 40th St, Seattle, WA 98107, United States | 609701 |
| 3797 | 47.658976 | -122.354915 | Fremont | Phinney Avenue North, Seattle, WA 98103, Unite... | 10118341 |
| 3798 | 47.655381 | -122.343205 | Fremont | Midvale Avenue North, Seattle, WA 98103, Unite... | 2614387 |
| 3799 | 47.652902 | -122.352110 | Fremont | Dayton Avenue North, Seattle, WA 98103, United... | 7735100 |
| 3800 | 47.663613 | -122.349519 | Fremont | Linden Avenue North, Seattle, WA 98103, United... | 5482204 |
| 3801 | 47.657078 | -122.358795 | Fremont | 1st Avenue Northwest, Seattle, WA 98107, Unite... | 4524575 |
| 3803 | 47.661131 | -122.349238 | Fremont | Linden Avenue North, Seattle, WA 98103, United... | 9698202 |
| 3804 | 47.660856 | -122.352401 | Fremont | N 44th st, Seattle, WA 98103, United States | 7178490 |
| 3805 | 47.653158 | -122.356285 | Fremont | 1st Avenue Northwest, Seattle, WA 98107, Unite... | 8054902 |
| 3806 | 47.656057 | -122.354514 | Fremont | Greenwood Avenue North, Seattle, WA 98103, Uni... | 5458027 |
| 3807 | 47.654304 | -122.342720 | Wallingford | Stone Way North, Seattle, WA 98103, United States | 4940491 |
| 3808 | 47.662036 | -122.350485 | Fremont | Dayton Avenue North, Seattle, WA 98103, United... | 1844791 |
| 3809 | 47.648689 | -122.343915 | Fremont | Albion Place North, Seattle, WA 98103, United ... | 6120046 |
| 3810 | 47.654205 | -122.352604 | Fremont | N Bowdoin Pl, Seattle, WA 98103, United States | 262764 |
| 3811 | 47.657898 | -122.346692 | Fremont | Whitman Avenue North, Seattle, WA 98103, Unite... | 8578490 |
| 3812 | 47.654516 | -122.358124 | Fremont | Northwest 39th Street, Seattle, WA 98107, Unit... | 3383329 |
| 3813 | 47.664295 | -122.359170 | Fremont | Northwest 48th Street, Seattle, WA 98107, Unit... | 8101950 |
| 3814 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 |
| 3817 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 |
3412 rows × 5 columns
Second, we want to know what neighbourhoods are most popular.
fig = go.Figure()
fig.add_trace(go.Histogram(x=listings_locations['neighbourhood'],name='neighbourhood'))
# Overlay both histograms
fig.update_layout(title = 'Seattle AirBNB Listings Distribution Per Neighbourhood', barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()
listings_locations.groupby('neighbourhood')['neighbourhood'].count().nlargest()
neighbourhood Capitol Hill 341 Ballard 208 Minor 189 Belltown 185 Queen Anne 185 Name: neighbourhood, dtype: int64
The most popular listings neighbourhood is: Capitol Hill.
Then almost equally popular: Ballard, Minor, Belltown, Queen Anne
fig = go.Figure(data=go.Scattergeo(
lon = listings_locations['longitude'],
lat = listings_locations['latitude'],
text = listings_locations['neighbourhood'],
))
fig.update_layout(
title = 'Seattle AirBNB Listings Locations Map',
geo_scope='usa',
)
fig.show()
Then, we will explore the price distribution for Seattle listing.
calendar['price']
0 $85.00
1 $85.00
2 NaN
3 NaN
4 NaN
5 NaN
6 NaN
7 NaN
8 NaN
9 $85.00
10 $85.00
11 NaN
12 NaN
13 NaN
14 $85.00
15 $85.00
16 $85.00
17 NaN
18 NaN
19 NaN
20 $85.00
21 $85.00
22 $85.00
23 $85.00
24 $85.00
25 NaN
26 NaN
27 NaN
28 $85.00
29 $85.00
...
1393540 NaN
1393541 NaN
1393542 NaN
1393543 NaN
1393544 NaN
1393545 NaN
1393546 NaN
1393547 NaN
1393548 NaN
1393549 NaN
1393550 NaN
1393551 NaN
1393552 NaN
1393553 NaN
1393554 NaN
1393555 NaN
1393556 NaN
1393557 NaN
1393558 NaN
1393559 NaN
1393560 NaN
1393561 NaN
1393562 NaN
1393563 NaN
1393564 NaN
1393565 NaN
1393566 NaN
1393567 NaN
1393568 NaN
1393569 NaN
Name: price, Length: 1393570, dtype: object
prices = calendar.dropna()
prices['price'] = prices.apply(lambda x: float(x['price'].replace('$','').replace(',','')), axis=1)
/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
fig = go.Figure()
fig.add_trace(go.Histogram(x=prices['price'],name='price'))
# Overlay both histograms
fig.update_layout(title = 'Seattle AirBNB Listing Price Distribution',barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()
prices['price'].describe()
count 934542.000000 mean 137.944859 std 105.062870 min 10.000000 25% 75.000000 50% 109.000000 75% 160.000000 max 1650.000000 Name: price, dtype: float64
it is clear that the average price is 137, with highest count for 150 range
Then, we will explore the price distribution for each neighbourhood.
listings_locations_calendar_merged = pd.merge(listings_locations , calendar, on='listing_id', how='outer').dropna()
listings_locations_calendar_merged = listings_locations_calendar_merged[listings_locations_calendar_merged['available']=='t'].drop(['date','available'],axis=1)
listings_locations_calendar_merged['price'] = listings_locations_calendar_merged.apply(lambda x: float(x['price'].replace('$','').replace(',','')), axis=1)
listings_locations_calendar_merged
| latitude | longitude | neighbourhood | street | listing_id | price | |
|---|---|---|---|---|---|---|
| 0 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 1 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 9 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 10 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 14 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 15 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 16 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 20 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 21 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 22 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 23 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 24 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 28 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 29 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 30 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 31 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 32 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 33 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 34 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 35 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 36 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 37 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 41 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 42 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 43 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 44 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 45 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 46 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 47 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| 48 | 47.636289 | -122.371025 | Queen Anne | Gilman Dr W, Seattle, WA 98119, United States | 241032 | 85.0 |
| ... | ... | ... | ... | ... | ... | ... |
| 1244992 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1244993 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1244994 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1244995 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1244996 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1244997 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 125.0 |
| 1244998 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 125.0 |
| 1244999 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245000 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245001 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245002 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245003 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245004 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 125.0 |
| 1245005 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 125.0 |
| 1245006 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245007 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245008 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245009 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245010 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245011 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 125.0 |
| 1245012 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 125.0 |
| 1245013 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245014 | 47.649552 | -122.318309 | Portage Bay | Fuhrman Avenue East, Seattle, WA 98102, United... | 8902327 | 79.0 |
| 1245015 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
| 1245016 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
| 1245017 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
| 1245018 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
| 1245021 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
| 1245022 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
| 1245023 | 47.641186 | -122.342085 | Queen Anne | Westlake Avenue North, Seattle, WA 98109, Unit... | 10208623 | 87.0 |
808718 rows × 6 columns
df = listings_locations_calendar_merged.groupby('neighbourhood').mean()
fig = px.bar(df, y=df.price, x=df.index, text=df.price)
fig.update_traces(texttemplate='%{text:.2s}', textposition='outside')
fig.update_layout(title = 'Seattle AirBNB Listing Average Prices For Each Neighbourhood', uniformtext_minsize=8, uniformtext_mode='hide')
fig.show()
listings_locations_calendar_merged.groupby('neighbourhood')['price'].mean().nlargest(50)
neighbourhood Portage Bay 250.885285 Industrial District 245.875441 Windermere 227.516092 Alki 226.410733 Westlake 225.336634 Central Business District 210.509103 Fauntleroy 205.882353 Magnolia 205.523503 Pike Place Market 204.686803 Belltown 201.061400 Pike Market 192.582019 Queen Anne 190.648790 South Lake Union 186.288490 Pinehurst 181.668142 Madrona 166.367724 Green Lake 164.928139 Montlake 163.139629 Lower Queen Anne 158.929664 First Hill 155.947990 North Admiral 155.736659 Pioneer Square 154.067182 Madison Park 145.502389 Fremont 141.962528 Seaview 141.670207 Yesler Terrace 141.037221 Minor 135.778037 Capitol Hill 135.456855 Broadway 134.753425 Leschi 133.423488 Wallingford 131.802042 South Beacon Hill 131.321212 South Park 128.338863 Arbor Heights 127.230769 Phinney Ridge 126.478765 Harrison/Denny-Blaine 126.464454 Ballard 125.943331 Atlantic 125.779920 View Ridge 124.224777 North Beach/Blue Ridge 122.300155 Haller Lake 121.955873 Genesee 121.610086 Gatewood 118.250151 Cedar Park 118.203544 Roosevelt 117.941571 International District 116.072308 Ravenna 115.721137 Stevens 115.673542 Laurelhurst 114.084595 Interbay 113.081671 Eastlake 111.225513 Name: price, dtype: float64
The most expensive listings neighbourhoods are: Portage Bay and Industrial District .
Then almost equally expensive: Alki,Westlake and Central Business District
The most expensive listings neighbourhoods are not the most popular listings. Popular listings are more in the mid range prices like the most popular listing Capitol Hill, which hase mean price of 135.